July 6th, 2011 by depesz | Tags: bloat, cluster, lock, locks, pg_reorg, postgresql, vacuum, waiting | 13 comments »
For various reasons, and in various cases, bloat happens. Theoretically autovacuum protects us all, but sometimes it doesn't. Sometimes someone disables it, or mis-configures, or bad planet alignment happens, and we end up in deep bloat. What to do then? Vacuum? ...
January 11th, 2010 by depesz | Tags: administration, cluster, maintenance, pg85, pg90, postgresql, reindex, vacuum | 13 comments »
Some time ago Josh Berkus wrote about possible changes in VACUUM FULL. Now these changes came to life. By now, I mean 6th of January, when Takahiro Itagaki committed his patch: Log Message: ----------- Support rewritten-based full vacuum as VACUUM FULL. Traditional VACUUM FULL was ...
