Re: Not HOT enough

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Not HOT enough
Дата
Msg-id 1322061559-sup-6871@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Not HOT enough  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Not HOT enough  (Robert Haas <robertmhaas@gmail.com>)
Re: Not HOT enough  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Excerpts from Robert Haas's message of mié nov 23 12:15:55 -0300 2011:

> > And it effects shared catalogs only, which are all low traffic anyway.
>
> I think "low traffic" is the key point.  I understand that you're not
> changing the VACUUM behavior, but you are making heap_page_prune_opt()
> not do anything when a shared catalog is involved.  That would be
> unacceptable if we expected shared catalogs to be updated frequently,
> either now or in the future, but I guess we don't expect that.

Maybe not pg_database or pg_tablespace and such, but I'm not so sure
about pg_shdepend.  (Do we record pg_shdepend entries for temp tables?)

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Not HOT enough
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Permissions checks for range-type support functions