Re: database is bigger after dump/restore - why? (60 GB to 109 GB)

Aleksey Tsalolikhin <atsaloli.tech@gmail.com> writes:
> i've installed the "pageinspect" contrib module as Tomas suggested but
> I don't know what to do with it or what to look at.  I looked at the
> manual for it but it's totally over my head right now.

Personally I'd try pgstattuple first:
http://www.postgresql.org/docs/8.4/static/pgstattuple.html

The stats from that for the table and each index should at least let us
narrow down where the bloat is.

            regards, tom lane