Re: vacuum analyze GROWS db ?! - Mailing list pgsql-general

From Tom Lane
Subject Re: vacuum analyze GROWS db ?!
Date
Msg-id 29583.1266249045@sss.pgh.pa.us
Whole thread Raw
In response to vacuum analyze GROWS db ?!  (Marcin Krol <mrkafk@gmail.com>)
Responses Re: vacuum analyze GROWS db ?!  (Marcin Krol <mrkafk@gmail.com>)
List pgsql-general
Marcin Krol <mrkafk@gmail.com> 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

pgsql-general by date:

Previous
From: Marcin Krol
Date:
Subject: Selection of index for CLUSTER
Next
From: Marcin Krol
Date:
Subject: Re: vacuum analyze GROWS db ?!