Re: [COMMITTERS] pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: [COMMITTERS] pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table
Дата
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E401388BB8@ratbert.vale-housing.co.uk
обсуждение исходный текст
Ответ на Re: [COMMITTERS] pgsql: Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.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@commandprompt.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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Luke Lonergan"
Дата:
Сообщение: Re: Table clustering idea
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: vacuum, performance, and MVCC