Re: [GENERAL] ANALYZE getting dead tuple count hopelessly wrong

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] ANALYZE getting dead tuple count hopelessly wrong
Дата
Msg-id 19331.1206993166@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] ANALYZE getting dead tuple count hopelessly wrong  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Ответы Re: [GENERAL] ANALYZE getting dead tuple count hopelessly wrong  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Список pgsql-hackers
"Pavan Deolasee" <pavan.deolasee@gmail.com> writes:
> On Mon, Mar 31, 2008 at 9:02 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> It looks like there's no trivial way to get ANALYZE to do things that
>> way, though.  heap_release_fetch() doesn't distinguish a DEAD line
>> pointer from an unused or redirected one.  But in the current
>> implementation of ANALYZE there's really no benefit to using
>> heap_release_fetch anyway --- it always examines all line pointers
>> on each selected page, so we might as well rewrite it to use a simple
>> loop more like vacuum uses.

> I agree. I would write a patch on these lines, unless you are already on to it.

Please do --- I have a lot of other stuff on my plate.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: SPI support needed for EXECUTE USING
Следующее
От: Tom Lane
Дата:
Сообщение: Re: POSIX shared memory support