New old "debug_parallel_query" setting in PostgreSQL 16
Naming variables Why will force_parallel_mode - the runtime option be renamed to debug_parallel_query in PostgreSQL 16? Proper variable and function […]
pg_timetable v5.3 is out!
Our team is proud to introduce a new pg_timetable v5.3 release! This time we focused solely on implementing new features […]
Go & PostgreSQL: FOSDEM 2023 talk
Intro On the 5th of February 2023, I had the privilege of giving a talk at the PostgreSQL devroom during […]
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 […]
usql? But why? usql is a universal command-line interface for many database. But why are we still using CLI (command […]
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. […]
Better SQL functions in PostgreSQL v14
by
Laurenz Albe |
07.2022We all know and value SQL functions as a handy shortcut. PostgreSQL v14 has introduced a new, better way to […]
