A recent blog posting by Frédéric Delacourt reminded me once again that in the analytics world customers sometimes ask for more than 1600 columns. But is that even possible?
Posted by ads' corner on Thursday, December 4, 2025
For this month's #PGSQLPhriday, Grant Fritchey asks: What is the one thing you wish you knew while you learn PostgreSQL.
Posted by ads' corner on Sunday, March 5, 2023
Someone at FOSDEM 2023 asked the question: 'What happens when PostgreSQL rolls over the version number to 95? Will this cause problems like back then in Windows?'
Posted by ads' corner on Wednesday, February 15, 2023
This month's #PGSQLPhriday topic: pick your three favorite or most important best pratices for #PostgreSQL. Tell them in a form that two are true, one is a lie. See if you can spot which one is true and which one is false. The resolution is at the end of this blog posting.
Posted by ads' corner on Friday, October 7, 2022
In September 2021, a patch for the upcoming PostgreSQL version 15 was committed which introduces a visible change for users: the 'CREATE' privilege for the 'public' schema is no longer set by default.
Posted by ads' corner on Tuesday, August 30, 2022
Jens Kubieziel recently posted a Twitter poll: 2 + 2 * 4
Posted by ads' corner on Friday, July 1, 2022
While attending a conference (yay) the discussion turned to system columns, and especially 'ctid'. This was in context of backups, and the physical position of data on disk. The question was if that can be used to determine if an incremental backup is required, and if it is enough to just copy that field where the 'ctid' points to. Not quite, but I’d like to use this question to describe the system columns more in detail.
Posted by ads' corner on Tuesday, June 28, 2022
The one thing I like to do is challenge PostgreSQL - and readers - to the extreme. A while ago I posted about the Beer o'clock. Building Zoé was another interesting example. And at some point I blog about Dancing with the Stars as well. Today it's all about nothing. Empty. Where is all the data gone?
Posted by ads' corner on Saturday, June 11, 2022
A couple days ago Devrim forked PostgreSQL to get a beer. That effort is of course laudable, but a bit extreme. PostgreSQL is very extensible, and allows to implement a beer now clock with just a few easy steps.
Posted by ads' corner on Tuesday, May 3, 2022
Christophe Pettus posted an interesting challenge. Two strings which on the surface look equal, but if you ask PostgreSQL to compare them, they are not equal.
Posted by ads' corner on Thursday, January 27, 2022