Re: reducing statistics write overhead

Поиск
Список
Период
Сортировка
От Martin Pihlak
Тема Re: reducing statistics write overhead
Дата
Msg-id 49777B44.10105@gmail.com
обсуждение исходный текст
Ответ на Re: reducing statistics write overhead  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: reducing statistics write overhead  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera wrote:
> I agree that pgstats is not ideal (we've said this from the very
> beginning), but I doubt that updating pg_class is the answer; you'd be
> generating thousands of dead tuples there.
> 

But we already do update pg_class after vacuum -- in vac_update_relstats().
Hmm, that performs a heap_inplace_update() ... I assume that this is cheap,
but have no idea as if it is suitable for the purpouse.

regards,
Martin



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

Предыдущее
От: Ron Mayer
Дата:
Сообщение: Re: Pluggable Indexes
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Pluggable Indexes