random pg scribbles

nullus est in vitae sensus ipsa vera est sensus

LZ4 and ZSTD pg_dump compression in PostgreSQL 16

LZ4 and ZSTD are additional pg_dump compression methods added in PostgreSQL 16. Find out how to use them, & how they compare to GZIP.

1 min read · April 25, 2023

2023 · compression pg_dump pg_restore update upgrade postgresql what's new
Underscores in numeric constants in PostgreSQL 16

PostgreSQL 16 includes support for underscores in integer and numeric constants. Learn how to use them in large numbers without errors.

1 min read · April 18, 2023

2023 · sql postgresql what's new
Parallel aggregate in PostgreSQL 16 for better performance

A new functionality for parallel aggregates on string_agg() and array_agg() functions is coming in PostgreSQL 16 with improved performance.

1 min read · April 11, 2023

2023 · array_agg concurrency parallel aggregate performance postgresql what's new
New old “debug_parallel_query” setting in PostgreSQL 16

force_parallel_mode - the runtime option will have a new name in PostgreSQL 16: debug_parallel_query. Find out why.

1 min read · March 28, 2023

2023 · GUC postgresql 16 what's new
pg_timetable v5.3 is out!

pg_timetable v5.3 release is here - new logging features include: disable database logging, plus 4 new ways to control file logging.

1 min read · March 15, 2023

2023 · bloat logging postgresql scheduler what's new