Re: [HACKERS] Protect syscache from bloating with negative cache entries - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Protect syscache from bloating with negative cache entries
Date
Msg-id 30868.1482246558@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Protect syscache from bloating with negative cache entries  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: [HACKERS] Protect syscache from bloating with negative cache entries
List pgsql-hackers
Craig Ringer <craig@2ndquadrant.com> writes:
> On 20 December 2016 at 21:59, Robert Haas <robertmhaas@gmail.com> wrote:
>> We could implement this by having
>> some process, like the background writer,
>> SendProcSignal(PROCSIG_HOUSEKEEPING) to every process in the system
>> every 10 minutes or so.

> ... on a rolling basis.

I don't understand why we'd make that a system-wide behavior at all,
rather than expecting each process to manage its own cache.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Time to drop old-style (V0) functions?
Next
From: Simon Riggs
Date:
Subject: Re: [HACKERS] Proposal for changes to recovery.conf API