random pg scribbles

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  

usql: universal psql?

1 min read   ·   January 17, 2023

2023   ·   psql   usql   postgresql  

Re: Creating 1 million users in PostgreSQL

Hans-Jürgen Schönig wrote a great post “Creating 1 million users in PostgreSQL”. I just love such things! Well done! Thanks. But since there is no possibility to leave comments under original post (BTW why?), I’ll create my own post. When testing such tricks always create temp database. Because I accidentally used… no, no, not the … Continue reading Re: Creating 1 million users in PostgreSQL →

2 min read   ·   December 19, 2017   ·   wordpress

2017

Code Quality Comparison of Firebird, MySQL, and PostgreSQL

I have read very interesting post “Code Quality Comparison of Firebird, MySQL, and PostgreSQL” today about static analysis of three open-source RDBMS. And I wonder, should we use static code analyzers on an ongoing basis, e.g. PVS Studio? tl;dr: So, the code-quality rankings are as follows: 1 place – Firebird and PostgreSQL. 2 place – … Continue reading Code Quality Comparison of Firebird, MySQL, and PostgreSQL →

1 min read   ·   November 29, 2017   ·   wordpress

2017