Re: Measuring relation free space

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: Bernd Helmle <mailings(at)oopsware(dot)de>, Greg Smith <greg(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Measuring relation free space
Date: 2012-01-14 19:40:46
Message-ID: CAJKUy5hbmC4u2kgPAtpkvGYTuWnCKUfvqseaLgQz3pz3RPWZ6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Jan 14, 2012 at 6:26 AM, Noah Misch <noah(at)leadboat(dot)com> wrote:
>
> - pgstattuple() and relation_free_space() should emit the same number, even if
>  that means improving pgstattuple() at the same time.

yes, i just wanted to understand which one was more accurate and
why... and give the opportunity for anyone to point my error if any

> - relation_free_space() belongs in the pgstattuple extension, because its role
>  is cheaper access to a single pgstattuple() metric.
>

oh! right! so, what about just fixing the free_percent that
pgstattuple is providing

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2012-01-14 20:06:27 Re: JSON for PG 9.2
Previous Message Ryan Kelly 2012-01-14 19:22:21 Re: [PATCH] Allow breaking out of hung connection attempts