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)
*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)