Re: vacuum analyze GROWS db ?!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marcin Krol <mrkafk(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum analyze GROWS db ?!
Date: 2010-02-15 15:50:45
Message-ID: 29583.1266249045@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marcin Krol <mrkafk(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ozz Nixon 2010-02-15 16:01:51 Multiple Server Installation/Design Question.
Previous Message Marcin Krol 2010-02-15 15:02:29 Selection of index for CLUSTER