Re: Great change (size of data dir) upgrading postgresql

"Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> The other thing is the reindex.

I favor the index-bloat idea as well, but it'd be a good idea to verify.
An easy check to make is to see which rows in pg_class have the largest
relpages values.

> Of course you could look at the files within the data/base directory tree and
> see which of those are consuming alot of disk space. These files are named
> after the oid, in pg_class, of the entity they contain.

Correction: data files are named per the relfilenode column of pg_class.
Database directories, however, are named per pg_database.oid.

			regards, tom lane