Re: Syscaches should store negative entries, too - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Syscaches should store negative entries, too
Date
Msg-id 1012416017.1923.3.camel@rh72.home.ee
Whole thread Raw
In response to Re: Syscaches should store negative entries, too  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Syscaches should store negative entries, too  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
On Thu, 2002-01-31 at 00:00, Tom Lane wrote:
> 
> To make negative cache entries work correctly, we'd have to issue
> cross-backend SI messages for inserts into the system catalogs, not
> only for updates and deletes.  This would mean more SI traffic than
> there is now.  I think it'd still be a win, but the case for negative
> cache entries isn't quite as airtight as I thought.  There could be
> scenarios where the extra SI traffic outweighs the savings from avoiding
> failing catalog searches.
> 
> Comments anyone?

The standard one - if not sure, make it an option ;)

------------
Hannu



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Syscaches should store negative entries, too
Next
From: Bruce Momjian
Date:
Subject: Re: Per-database and per-user GUC settings