The EDB Blog

Controlling Autovacuum


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

PostgreSQL: Aggregate Push-down in postgres_fdw


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


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