Smart Postgres News and Techniques 2025 Vol 4

If you use Roman numerals like MMXXV, you’ll be thrilled to know that Postgres 18 is adding more support for it as Hubert Lubaczewski explains. Also, I have questions about your app.


If you’re making a change to a big table, like changing a data type or introducing a default value, Greg Sabino Mullane shows how to test whether your change will require a full rewrite of the table.


Wanna watch a web page run a query? ByteByByte.dev connects to Postgres and runs SELECT NOW() while showing an annotated list of everything in the network packets going back and forth.


If you want to understand why a Postgres change was made, it’s more time-intensive and manual labor than you might think, as Laurenz Albe demonstrates. Those of you with a more modern development workflow will be used to using just Github and clicking through pull requests & issues, but Postgres has been around longer than that, so the workflow is much more complex.

Previous Post
Smart Postgres News and Techniques 2025 Vol 3
Next Post
Smart Postgres News and Techniques 2025 Vol 5

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed