| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| 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 16:11:26 |
| Message-ID: | 20100215161126.GA5735@depesz.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Leonardo F | 2010-02-15 16:19:09 | Re: Selection of index for CLUSTER |
| Previous Message | Marcin Krol | 2010-02-15 16:04:14 | Re: vacuum analyze GROWS db ?! |