The EDB Blog

PostgreSQL

PostgreSQL is the world’s most advanced open source object-relational database management system. It was developed by the PostgreSQL Global Development Group.

Partitioning
Default Partition - Adopting the Odds
June 26, 2018

PostgreSQL 10 introduced declarative partitioning, which included list and range partitioning. But, it had always been an open question as to what...

Parallel Index Scans
Parallel Index Scans in PostgreSQL
June 12, 2018

There is a lot to say about parallelism in PostgreSQL. We have come a long way since I wrote my first post on this topic (Parallel Sequential Scans)...

Built-in Sharding for PostgreSQL
May 22, 2018

Built-in sharding is something that many people have wanted to see in PostgreSQL for a long time. It would be a gross exaggeration to say that...

Row Movement Across PostgreSQL Partitions Made Easy
May 15, 2018

Before declarative partitioning was introduced in PostgreSQL 10, one had to use table inheritance. One of the main drawbacks of using table...

SERIALIZABLE in PostgreSQL 11... and beyond
May 8, 2018

Thanks to the tireless work of Google Summer of Code student Shubham Barai with the support of reviewers, a mentor, and a committer, PostgreSQL 11...

Do You Have the Essential Skills to Be a Successful PostgreSQL DBA?
May 4, 2018

Open source databases are becoming an increasingly preferred option for organizations seeking high performance, lower cost alternatives to legacy...

Intermediate Certificates
April 10, 2018

I previously mentioned the importance of high quality documentation, so we are always looking for improvements. This email thread from 2013 attempted...

Wal and Xlog
April 3, 2018

Postgres isn't the best at naming things. Of course, there is the old computer saying, "There are only two hard things in Computer Science: cache...

Containing Bloat with Partitions
March 27, 2018

PGConf India 2018 attracted a large number of PostgreSQL users and developers. I talked about "query optimization techniques for partitioned tables"...

Zheap: A Storage Engine to Provide Better Control Over Bloat
March 20, 2018

In the past few years, PostgreSQL has advanced a lot in terms of features, performance, and scalability for many core systems. However, one of the...

Get Postgres Tips and Tricks

Subscribe to our newsletter to get advanced Postgres how-tos.

Top Authors
Before joining EnterpriseDB, Marc spent almost 4 years at Polycom, the leading maker of video co…
Vibhor Kumar is Chief Performance Architect wit…
Senior Vice President, Marketing Frank Days is EDB's Vice President of Marketing. He h…
Raghavendra Rao is a Managing Consultant in Professional Ser…
Phil has 25 years experience working with relational database systems and is a Senior Consultant…