The EDB Blog

The Power of APIs in EDB Postgres Ark

English
2/6/2017

EnterpriseDB® (EDB™) created the EDB Postgres Ark™ to simplify the process of provisioning robust Postgres deployments, while also providing the benefits of cloud...

Creating SSL Certificates

English
01/13/2017

Having covered the choice of certificate authorities, I want to explain the internals of creating server certificates in Postgres....

The pg_rewind Improvements in PostgreSQL 9.6

English
01/11/2017

The pg_rewind tool was first introduced in PostgreSQL 9.5. This is best used in a situation when a standby becomes a master, then the old master can be reattached...

Controlling Autovacuum

English
01/09/2017

Unlike other database systems, Postgres makes the cleanup process visible and tunable to users....

PostgreSQL: Aggregate Push-down in postgres_fdw

English
11/23/2016

It's exciting times in PostgreSQL for those who are using postgres_fdw or Foreign Data Wrappers (FDWs) in general. Users often complained that a simple count(*) on a foreign table was slow since PostgreSQL required to pull all the rows from the foreign server just to count them to produce count...

EDB Ark: DBaaS for Hybrid Cloud Deployments

English
12/13/2016

The accelerated pace of application development means most enterprises can no longer wait for traditional IT to lead those initiatives. Traditional IT practices that required...

Partition Pruning in EDB Postgres 9.5

English
12/19/2016

One of my colleagues who was recently working with a customer has presented a customer case. According to him, the customer has a partitioned table and EDB Postgres™...

Data Backup Made Easy

English
11/04/2016

Backup strategies are critical to enterprise data management, but the time, storage, and management requirements pose a host of challenges. Because companies are...

Why it’s Cool to be an OLTP Database Again

English
10/24/2016

In 2012, the research firm Gartner defined the Logical Data Warehouse (LDW) as “a new data management architecture for analytics which combines the strengths of...

Analyzing Postgres Adoption

English
10/05/2016

As an open source project, the Postgres community has always had great difficulty in measuring many aspects of Postgres adoption....