Skip site navigation (1) Skip section navigation (2)

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: 2006-06-27 07:22:54
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E401388BB8@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-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

In response to

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2006-06-27 07:38:11
Subject: Re: vacuum, performance, and MVCC
Previous:From: Luke LonerganDate: 2006-06-27 06:31:24
Subject: Re: Table clustering idea

pgsql-committers by date

Next:From: Andrew DunstanDate: 2006-06-27 13:54:42
Subject: Re: pgsql: Clamp last_anl_tuples to n_live_tuples, in
Previous:From: User FxjrDate: 2006-06-27 04:35:22
Subject: npgsql - Npgsql: 2006-06-27 Francisco Figueiredo Jr.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group