On Mon, Feb 15, 2010 at 05:04:14PM +0100, Marcin Krol wrote: > Tom Lane wrote: >> 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. > > Oh great. Another catch. What are those functions? Well, this "catch" is clearly described in pg_class description: http://www.postgresql.org/docs/current/static/catalog-pg-class.html as for those functions - http://www.postgresql.org/docs/current/interactive/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: depesz@xxxxxxxxxx / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
