The EDB Blog

Built-in Sharding for PostgreSQL

5/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 PostgreSQL 11 (due to be released this fall) is capable of real sharding, but it seems pretty clear that the momentum is building. The capabilities already...

GDPR Will Turn DBAs Into Superheroes

5/18/2018
The world is awash with statistics about the General Data Protection Regulation (GDPR) and depending on who you believe, companies are either completely ready ( this study says 72% of global businesses are confident of compliance) or there is still a large portion of companies who will not achieve...

Row Movement Across PostgreSQL Partitions Made Easy

5/15/2018
Before declarative partitioning was introduced in PostgreSQL 10, one had to use table inheritance. One of the main drawbacks of using table inheritance is that ROW triggers are needed for the parent table to automatically route the inserted row to the right child table, which is cumbersome and slow...

GDPR Could Become a Costly Millstone that Slows Down Business Agility

5/10/2018
The General Data Protection Regulation (GDPR) has been one of the large ticket items for IT departments in the last year. According to PWC , 68% of large US multinationals will have spent between $1 million and $10 million on GDPR readiness and compliance in the lead up to the May 25, 2018 deadline...

SERIALIZABLE in PostgreSQL 11... and beyond

5/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 will ship with predicate lock support for hash indexes , gin indexes and gist indexes . These will make SERIALIZABLE transaction isolation much more...

Do You Have the Essential Skills to Be a Successful PostgreSQL DBA?

5/4/2018
Open source databases are becoming an increasingly preferred option for organizations seeking high performance, lower cost alternatives to legacy databases. According to a report by Gartner Research, more than 70% of new in-house applications will be developed on an open-source DBMS. 1 As...

Running EDB Postgres Failover Manager Without Sudo

4/24/2018
In the default mode of operation, EDB Postgres Failover Manager (EFM) agents run as the ‘efm’ operating system user. The agent uses sudo to perform various operating system and database tasks. More information about how sudo is used is in the Extending Failover Manager Permissions section of the...

EnterpriseDB Updates Tools, and Enhances Security and Alerting

4/19/2018
Database administrators need tools for database maintenance, performance optimization, and configuration as well as creating a highly available supportive infrastructure. EnterpriseDB (EDB) leads the industry in creating best-in-class Postgres tools to support DBAs with their mission critical...

Intermediate Certificates

4/10/2018
I previously mentioned the importance of high quality documentation, so we are always looking for improvements. This email thread from 2013 attempted to codify the rules for how to properly use intermediate ssl/tls certificates with Postgres. At this time, our documentation was updated to recommend...

Encryption Module in EDB Postgres Earns FIPS 140-2 Validation

4/6/2018
U.S. government agencies and other organizations that require higher levels of security now have another green light on the road to open source. The Cryptographic Module Validation Program (CMVP), operated by the National Institute of Standards and Technology (NIST), has awarded a coveted FIPS 140-...

Wal and Xlog

4/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 invalidation and naming things." With Postgres being 31 years old and developed by several different project teams, naming can be even more inconsistent...

Containing Bloat with Partitions

3/27/2018
PGConf India 2018 attracted a large number of PostgreSQL users and developers. I talked about "query optimization techniques for partitioned tables" ( slides ). Last year, I had held an introductory talk about PostgreSQL's declarative partitioning support ( slides ). Many conference participants...

Zheap: A Storage Engine to Provide Better Control Over Bloat

3/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 problems that many enterprises still complain is that its size increases over time which is commonly referred to as bloat. My colleague Robert Haas has...

Introduction to Parallel Sequential Scan

3/13/2018
In this video, we will have a look at how parallel sequential scan can be used in EDB Postgres Advanced Server to enhance the performance of the queries. Additionally, we will also have a look at the important parameters related to it, and discuss the scenarios where it does or does not boost the...