random pg scribbles

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  

Reserve connections for the pg_use_reserved_connections group in PostgreSQL 16

A brand-new patch in PostgreSQL 16 provides a way to reserve connection slots for non-superusers. Find out the news here!

1 min read   ·   February 07, 2023

2023   ·   resources   connection   performance   postgresql 16   what's new