"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