The dump takes about 30 minutes and restore on an older dev machine took several hours to complete. I did create a cluster on the restored (un-bloated) table and it finished in ~10 minutes and I should have space for the extra copies since the actual data is very small. I had looked at pg_reorg, but the bosses don't want me using something that hasn't been cleared, otherwise it looks pretty handy to have. Thanks for the point about cluster being the current vacuum full, and for the opinion in general. Someday I hope all our customer can use a more up to date version and I'll be making it more a point if I end up filling some DBA role here officially. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Massive-table-bloat-tp5736111p5736151.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
