Waiting for 8.4 – hash based DISTINCT
Today Tom Lane committed patch which gives DISTINCT ability to use hash aggregate – just like GROUP BY.
Search Results for: waiting for 9.4
Waiting for 8.4 – partial-match support in GIN, and sequence restart
Today we have two interesting patches: patch by Teodor Sigaev and Oleg Bartunov, and committed by Tom Lane, which adds interesting capability to GIN indexes patch by Zoltan Boszormenyi, also committed by Tom, which adds “RESTART” option to ALTER SEQUENCE. With some interesting consequences
Waiting for 8.4 – “EXPLAIN VERBOSE”
Tom Lane committed his patch which modifies output of “EXPLAIN VERBOSE” command.
Understanding pg_stat_activity
pg_stat_activity is system view that shows what is currently happening in the DB. With newer pgs it’s rather wide (22 columns as I write this). And, it’s not always obvious what all this means. So let’s try to figure it out.
Partitioning – what? why? how?
Recently I noticed that more and more cases that I deal with could use some partitioning. And while theoretically most people know about it, it’s definitely not a very well-understood feature, and sometimes people are scared of it. So, I’ll try to explain, to my best knowledge, what it is, why one would want to … Continue reading “Partitioning – what? why? how?”
Pagination with fixed order
Some time ago I wrote about getting fast pagination. While fast, it had some problems which made it unusable for some. Specifically – you couldn’t get page count, and easily jump to page number N. I did some thinking on the subject, and I think I found a way to make it all work. Quite … Continue reading “Pagination with fixed order”