Re: Massive table bloat

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.