Looong time ago, I wrote a piece about removing bloat by moving rows away from the end of table, and vacuuming it. This is/was very slow, and was optimized (to some extent) by Nathan Thom, but his blogpost vanished. Besides, later ...

December 9th, 2012 by depesz | Tags: , , , , , , , | 2 comments »

In PostgreSQL 8.4 we got CTE - Common Table Expressions. Since then we have this great tool available, but apparently for some people it's still black magic. CuTE, but still magic. I'll try to make it a bit less magical, ...

On 25th of February, Tom Lane committed patch: Support data-modifying commands (INSERT/UPDATE/DELETE) in WITH. This patch implements data-modifying WITH queries according to the semantics that the updates all ...