Reserve connections in PostgreSQL 16
Reserve connections for the pg_use_reserved_connections group in PostgreSQL 16 Nathan Bossart implemented a brand-new patch that provides a way to […]
hex, oct, bin integers in PostgreSQL 16
SQL and integer notations NEW in PostgreSQL 16 - support for non-decimal notation of integer constants! PostgreSQL already has powerful […]
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.