PostgreSQL’s High Performance in Action
Proofs in benchmark results
PostgreSQL has been tested and proven in many tests. Equnix’ internal benchmarks confirms their results.
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)
The History of PostgreSQL
INGRES, began as the academic research in UCB by Prof Michael STONEBRAKER, implementing Whitepaper from Edgar. F. Codd.
POSTGRES began development from 1986-1994, as continuation of INGRES with object relational technology. POSTGRES commercialize as ILLUSTRA, later become INFORMIX, and purchased by IBM 1 billion dollars.
Became Postgres95, because POSTQUEL replaced by SQL Languages
PostgreSQL as new career in Open Source. PostgreSQL has actively Maintained, Develops, QC by PostgreSQL Global Development Group consists Hackers, Academics, Professionals all around the World.
At Present, Many organizations, government agencies and companies use PostgreSQL. You will find installations in ADP, CISCO, NTT Data, NOAA, Research In Motion, The US Forestry Service and The American Chemical Society. Today, it's rare to find a large corporation or government agency which isn't using PostgreSQL in at least one department.
The Timeline of PostgreSQL
For more than 23 years has been using by many vendors as a base to create another products, thanks to BSD-Like licensing.
Some Big Corporation interest in PostgreSQL:
- FUJITSU (Enterprise PostgreSQL)
- IBM (Netezza)
- Amazon (Redshift)
- Yahoo (Everest)
- Instagram (as their base system)
Synchronous Streaming Replication
Asynchronous Streaming Replication
Point-In-Time Recovery (PITR)
HA - Hot-Standby Replication
Only 10 seconds to Failover
Replica promoted to Master when Real Master down
Hassle Free PostgreSQL Solution with Equnix
Equnix' comprehensive services offering for PostgreSQL
Equnix delivers PostgreSQL Managed Services for clients needing total support.
- Time to Resolution Maximum is 4 hours.
- Consultation included.
- SLA up to 99,99 % (maximum tolerable downtime: 52 minutes/year).
Professional services that help maintain your database.
Equnix provides professional maintenance services to help maintain your PostgreSQL database system with local support, including:
|Preventive Maintenance (PM)||Corrective Maintenance (CM)|
- Time to Respond max 1 hour.
- Time to On-Site max 4 hours.
- Time to Resolve (Fix/Workaround) max 4 hours.
PostgreSQL Advanced Training
PostgreSQL Training for those who’s eager to learn more about the World’s Most Advanced ORDBMS. Our Training improves your knowledge on PostgreSQL, both on fundamentals and Advanced levels. It’s taught by our experienced experts and best practitioners in PostgreSQL.
We provide 2 level of training:
- In house Basic PostgreSQL: Covering basic knowledge on SQL and general RDBMS.
- In house Advanced PostgreSQL: Covering detailed knowledge about PostgreSQL foundations and Performance Experience for Developer or General Database Administrator.
Our training is backed with Professional Certification.
Advanced database features for PostgreSQL Services from Equnix
Supporting businesses with Enterprise class features
PostgreSQL is delivered with local professional support from Equnix, up to 24 hours a day, 7 days a week. With our qualified professional talents and experiences in managing and maintaining PostgreSQL database system in enterprise business clients, we ensure your system is always up and running.
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. There has never been a report of PostgreSQL crash from Equnix clients. Banking and Telco operators benefit greatly from this feature.
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.
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.
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.
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.
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.
PostgreSQL is capable of providing minimum downtime guarantee. Tuning and configuration from Equnix with High Availability or Cyclic High Availability concepts enables PostgreSQL to provide up to 99.9% 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 increases your database server’s overall service operation availability and make sure there’s no hassle in handling unplanned downtimes.
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.
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.
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.
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.