pg_dump compression specifications in PostgreSQL 16
What is pg_dump compression? pg_dump is a PostgreSQL utility for backing up a local or remote PostgreSQL database. It creates […]
GRANT VACUUM, ANALYZE in PostgreSQL 16
What is GRANT VACUUM, ANALYZE? PostgreSQL uses table VACUUM and ANALYZE commands to optimize the database. The VACUUM command reclaims […]
Aliases for sub-SELECTS in FROM clause
What are aliases in SQL? SQL aliases in FROM clauses are used to give a result set a temporary name. […]
pgwatch2 v1.9 Beta released and available for testing
We want to announce that the beta release of pgwatch2 v1.9 is now available for download. This release contains previews […]
pg_timetable v4.4 is available immediately!
Our team is proud to introduce a new pg_timetable v4.4 release! This time we focused on implementing a couple of […]
pg_timetable v4 is out and available immediately!
Our team is proud to introduce a new major pg_timetable v4 release! This time a huge amount of work has […]
pg_read_all_data - a system level "read all data" role for PostgreSQL!
A new feature has arrived: "pg_read_all_data" - a predefined role that can run an unfettered pg_dump without that role being a superuser.
Having a 2nd look at Postgres v13 improvements
In this post Kaarel is highlighting some changes that stood out to him on the 2nd reading of the release notes of Postgres v13.
pg_timetable: start-up improvements
¡Hola, queridos amigos! We've released several valuable features for pg_timetable in May. It's summer already, and time is flying fast! […]
