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: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 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 04:12:13
Message-ID: 8953.1151381533@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
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
--- which is not a very strong argument, certainly, but the argument in
favor of changing seems even weaker.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Luke LonerganDate: 2006-06-27 06:31:24
Subject: Re: Table clustering idea
Previous:From: Alvaro HerreraDate: 2006-06-27 03:56:57
Subject: Re: [COMMITTERS] pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table

pgsql-committers by date

Next:From: User FxjrDate: 2006-06-27 04:35:22
Subject: npgsql - Npgsql: 2006-06-27 Francisco Figueiredo Jr.
Previous:From: Alvaro HerreraDate: 2006-06-27 03:56:57
Subject: Re: [COMMITTERS] pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table

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