Re: Syscaches should store negative entries, too

Hannu Krosing wrote:
> 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 ;)

Actually, that is not our standard comment.  We want to give people a
limited set of meaningful options.  If then want billions of options,
they should use Oracle.  :-)

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026