waiting for pg 8.4
on sunday, 23rd of march, tom lane commited another new-feature patch. this new patch was from brendan jurd, and adds quote_nullable() function:
on sunday, 23rd of march, tom lane commited another new-feature patch. this new patch was from brendan jurd, and adds quote_nullable() function:
yesterday, tom lane committed another great feature. actually it’s so great, that i really wonder how could i live without it earlier. patch came from itagaki takahiro, and was heavily modified by tom. what it does?
today (2008-03-10) magnus hagander commited patch which adds new, quite handy functionality: “enum type for guc parameters”.
i will try to follow development of 8.4, and write examples of what’s possible with it, based on current HEAD code. of course there is no guarantee that it will work in final, released 8.4 (it is a bit too early to talk about it, but given the fact that the patch got committed, there … Continue reading “waiting for pg 8.4”
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.
A bit ago I wrote a blog post that was supposed to show how to keep number of rows in table to N per some category. Unfortunately, I overlooked a problem related to concurrency.
Recently I was in a situation where autovacuum couldn’t keep up with changes. To solve the problem I finally decided to manually vacuum analyze all tables (manual vacuum/analyze is faster than one ran by autovacuum daemon). But it irritated me that I didn’t have ready way to check which tables are waiting for autovacuum to … Continue reading “Which tables should be auto vacuumed or auto analyzed?”
Recently I’ve seen case like: application had to add column to table. application ran ALTER TABLE ADD COLUMN (without default!) everything stopped for many MINUTES Why? How to avoid the problem?
Lately reader of my blog asked about some detail, and then in next comment said that he doesn’t have PostgreSQL 12 (which is currently developed version of Pg) available. Well, I answered the original question, but I figured that if someone is reading my Waiting for … series, then it would make sense that such … Continue reading “How to play with upcoming, unreleased, PostgreSQL?”
I am doing quite a lot of work inside tmux. I especially love that I can start multiple windows/panes and use them to run the same thing across multiple servers, while still having normal shell access between steps. This thing was greatly improved when I wrote tmux_send_to_many, but one thing was missing – waiting for … Continue reading “Wait for program(s) in tmux panes to end…”