Marcin Krol <mrkafk@xxxxxxxxx> writes: > The app that created this db is written by me for a change. But I've > done simple VACUUM ANALYZE on the biggest table in db and got this: Do you *know* that relpages was up to date before that? If your system only does manual vacuums then those numbers probably reflected reality as of your last vacuum. There are functions that will give you true file sizes but relpages ain't it. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general