Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [COMMITTERS] pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table
- 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: Tue, 27 Jun 2006 08:22:54 +0100
- Message-id: <E7F85A1B5FF8D44C8A1AF6885BC9A0E401388BB8(at)ratbert(dot)vale-housing(dot)co(dot)uk>
> -----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
- References:
- Prev by Date: Re: Table clustering idea
- Next by Date: Re: vacuum, performance, and MVCC
- Previous by thread: Re: [COMMITTERS] pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table
- Next by thread: Turning off disk caching
- Indexes: