Search Postgresql Archives

Re: vacuum analyze GROWS db ?!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux