Waiting for 8.4 – psql vs. tabs + wrapped output
Today I will describe 2 new patches which modify psql:
Search Results for: WAITING FOR POSTGRESQL 10
Waiting for 8.4 – RETURN QUERY EXECUTE and cursor_tuple_fraction
Today another two new additions to PostgreSQL – as You can see may commit-fest seems to work pretty good 🙂
Waiting for 8.4 – \o and \d+ in psql
Today, we have 2 new changes in psql. One of them is not actually new feature, but I decided to write about it anyway, because of its implications.
waiting for pg 8.4
today (2008-03-10) magnus hagander commited patch which adds new, quite handy functionality: “enum type for guc parameters”.
waiting for pg 8.4
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”
What is LATERAL, what is it for, and how can one use it?
Lately in couple of places I recommended people that they can solve their problem with queries using LATERAL. In some cases recipient of such suggestion indicated that they had no idea what LATERAL is. Which made me think that it might be good idea to write more about them (lateral queries)… Also – I know … Continue reading “What is LATERAL, what is it for, and how can one use it?”
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.
How to get list of elements from multiranges?
So, some time ago, Pg devs added multi ranges – that is datatype that can be used to store multiple ranges in single column. The thing is that it wasn’t really simple how to get list of ranges from within such multirange. There was no operator, no way to split it. A month ago Alexander … Continue reading “How to get list of elements from multiranges?”
Which tables should be auto vacuumed or auto analyzed?
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?”
Migrating simple table to partitioned. How?
Recently someone asked, on irc, how to make table partitioned. The thing is that it was supposed to be done with new partitioning, and not the old way. The problem is that while we can create table that will be seen as partitioned – we can’t alter table to become partitioned. So. Is it possible?