| From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com> |
| Cc: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [COMMITTERS] pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table |
| Date: | 2006-06-27 07:22:54 |
| Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E401388BB8@ratbert.vale-housing.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
> Sent: 27 June 2006 05:12
> To: Alvaro Herrera
> Cc: Hackers
> Subject: Re: [HACKERS] [COMMITTERS] pgsql: Clamp
> last_anl_tuples to n_live_tuples, in case we vacuum a table
>
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > On a loosely related matter, how about changing pg_class.relpages to
> > pg_class.reldensity?
>
> IIRC, I considered this earlier, and rejected it because it
> doesn't cope
> well with the corner case relpages == 0. Also, it'll break existing
> clients that expect to find relpages and reltuples, if there are any
There are.
/D
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2006-06-27 13:54:42 | Re: pgsql: Clamp last_anl_tuples to n_live_tuples, in |
| Previous Message | User Fxjr | 2006-06-27 04:35:22 | npgsql - Npgsql: 2006-06-27 Francisco Figueiredo Jr. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2006-06-27 07:38:11 | Re: vacuum, performance, and MVCC |
| Previous Message | Luke Lonergan | 2006-06-27 06:31:24 | Re: Table clustering idea |