random pg scribbles

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  

ER diagrams with SQL and Mermaid

Generate an ER diagram for a PostgreSQL database using plain SQL and Mermaid. Explore entity relationship diagrams for architecture/dev

1 min read   ·   February 21, 2023

2023   ·   architecture   development   diagram   ER   visualisation  

Go & PostgreSQL: FOSDEM 2023 talk

1 min read   ·   February 15, 2023

2023   ·   conference   go   postgresql   presentation   slides   talk   fosdem   video