Re: Not HOT enough - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Not HOT enough
Date
Msg-id 1322061559-sup-6871@alvh.no-ip.org
Whole thread Raw
In response to Re: Not HOT enough  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Not HOT enough
Re: Not HOT enough
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: Not HOT enough
Next
From: Alvaro Herrera
Date:
Subject: Re: Permissions checks for range-type support functions