Get the world’s most advanced database with PostgreSQL

The Enterprise Class Database Management System

Here comes the new PostgreSQL 10! Download here

Join our Community!

PostgreSQL is an excellent database management system for use in enterprise class businesses. It is capable of handling high workload levels constantly and robustly. With more than 30 years of active development, PostgreSQL proves an equal, and even better database system for enterprises. PostgreSQL provides reliability, data integrity and correctness through a strong architecture, with the add-in advantage of no licensing fees or vendor lock-in.

PostgreSQL 10 new features :

Native Partitioning

Table partitioning without using rules or trigger, more scalable partitioning.

Parallel Query Execution

Query can be executed by multiple processes to speed up execution time, including index scan, aggregation, and sequential scanning.

Logical Replication

Add Table-level Replication features and publisher/subscriber mechanism.

Quorum Commit for Synchronous Replication

Improves the synchronous_standby_names GUC by adding the FIRST and ANY keywords to prioritize the standbys.

Connection Failover and Routing in libpq

Allowing applications to define multiple connection points and some properties that are expected from the backend server.

XMLTABLE is an SQL

Standard feature that allows transforming an XML document to table format, making it much easier to process XML data in the database.

Full Text Search support for JSON and JSONB

You can now create Full Text Indexes on JSON and JSONB columns.

SCRAM-SHA-256 Authentication

SCRAM is more secure than MD5 and has become the standard way to do authentication, by implementing salt to communicate in authentication process.

Restrictive Policies for Row Level Security

In addition to the SQL-standard privilege system available through GRANT, tables can have row security policies that restrict, on a per-user basis, which rows can be returned by normal queries or inserted, updated, or deleted by data modification commands.

Enhancement in file_fdw

Can execute a program or script within file_fdw foreign table.

Advanced database features for PostgreSQL
Supporting businesses with Enterprise class features

Scale Up with Parallel Query

Version 10 adds support for parallelizing some query operations, enabling utilization of several or all of the cores on a server to return query results faster. This release includes parallel sequential (table) scan, aggregation, and joins. Depending on details and available cores, parallelism can speed up big data queries by as much as 32 times faster.

High Availability

PostgreSQL is capable of providing minimum downtime guarantee. Tuning and configuration with High Availability or Cyclic High Availability concepts enables PostgreSQL to provide up to 99.99% up-time level for your database, which translates into less than one hour of downtime per year.

Failover in 10secs

With High Availability in place, PostgreSQL can guarantee maximum Failover time of only 10 seconds or less. This increase your database server’s overall service operation availability and making sure there’s no hassle in handling unplanned downtimes.

High Performance OLTP

PostgreSQL supports Online Transactional Processing demands of stable and robust handling of constantly high read-write workloads, while maintaining data integrity and security. Banking and Telco operators benefit greatly from this feature.

Multi-Master Replication

PostgreSQL supports various modes of data replication between server nodes, including Multi-Master Replication, that enables multiple node to have the Master status at the same time. This supports Distributed Workload across geographies, Load Balancing, Clustering, and data management design ease, to cater dynamic data collection.

Load Balancing / Clustering

PostgreSQL supports balancing workloads between database servers through implementation of Load Balancing and Clustering concepts. This mainly avoids overload in any of the server nodes, while at the same time optimizes resource utilization, maximize throughput, minimizes response time, and reduces hardware cost through scaling out, which is far more affordable than scaling up.

Point-in-Time Recovery (PITR)

PostgreSQL is capable of doing multiple modes of backup and recovery, including Point-in-Time Recovery. This provides the database system with a “Time Machine”, which enables it to recover from any crash to a certain point in time through use of write-ahead logs. With the possibilities of human error, this can save the world for you.

DRC Ready

With the previous features, plus Native Asynchronous Replication, Full/Incremental Backup and recovery modes, and ease of data resynchronization mechanisms, PostgreSQL is able to support the full feature set of Disaster Recovery Center (DRC) readiness, enabling your database to recover from any disaster, without adding more cost/tools.

Migration from any Database

PostgreSQL’s architecture is so flexible that it supports migration from any existing database system, both relational or non-relational models. One of great features is Foreign Data Wrappers which enable any foreign database to be linked to PostgreSQL. Database migration is never been this easier.

NoSQL / Big Data Support

Although it is Relational by design, PostgreSQL also supports NoSQL for handling Big Data and using JSONB (JSON Binary) in storing JSON documents type data. This extends PostgreSQL’s usage reach out to not only structured data but also to the rapidly developing unstructured data. This capability ensure removes doubt in choosing between SQL or NoSQL as we can have both at the same time.

Flash Reporting

PostgreSQL has sophisticated features to fetch data in every possible complex queries. With enhanced power of parallel processing, query execution time can be sliced down while maximizing the available resources. Moreover, the parallel processing can optimize index usage and result aggregation to construct "well-done" data. This OLAP-friendly feature fastened reporting generation, especially when the database is profiled as data warehouse.

Native Scalability

Needs of flexible storage for huge data growth is covered in PostgreSQL's Native Partitioning implementation. Data can be chunked into several partitions based on the constraints, while querying the main table may gives aggregated results. On-demand partition may be added as easily as running a single query, without altering whole rules which have been configured earlier. By combining with tablespaces, PostgreSQL gives easiness and agility to setup persistence infrastructure.

Easy Centralized Consolidation

In the latest advancement, PostgreSQL is enchanced with Logical Replication, as another option for Native Streaming Replication. Logical Replication can be configured per database or per table. With table replication, we can consolidate any transaction from all around the World without hassle into single location. Table replication is the next big thing for distributed system, distributed applications, and it will disrupt on how we developed distribution applications.

Omni Data Interoperability

PostgreSQL gives choices to select from where you want to fetch data, natively and externally. External data such as XML, CSV, Plain Text File, or even other RDBMS can be accessed within PostgreSQL instance. PostgreSQL enables result combination of these external reference and native data tables. On latest version of PostgreSQL, you can intepret your XML documents and aggregate with other tables to get comprehensive results for your reporting.

PostgreSQL’s High Performance in Action
Proofs in benchmark results

PostgreSQL has been tested and proven in many tests (*Results may vary)

PostgreSQL vs Oracle Performance Comparison on Intel E5-2643 machine. PostgreSQL exceeds Oracle by 7 times!
PostgreSQL performance comparison on IBM Power8 Machine. Achieving 27K+ QPS on IBM Power8.

*The benchmarks were done in accordance to the world standard TPC-B and TPC-C transactional database standards. The standards were created and maintained by the Transaction Performance Processing Council, a non-profit corporation focused on developing data centric benchmark standards. (www.tpc.org)

Need further information?

Don't hesitate to Call us at 0811-11-888-12
Or fill out the interactive form below

I would like to...