The EDB Blog

Controlling Autovacuum

01/09/2017

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

PostgreSQL: Aggregate Push-down in postgres_fdw

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...

Data Backup Made Easy

11/04/2016

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