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

From Bruce Momjian
Subject Re: Syscaches should store negative entries, too
Date
Msg-id 200202011932.g11JWZM29513@candle.pha.pa.us
Whole thread Raw
In response to Re: Syscaches should store negative entries, too  (Hannu Krosing <hannu@krosing.net>)
List pgsql-hackers
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
 


pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: sql select query with column 'AS' assignment
Next
From: Tom Lane
Date:
Subject: Re: Per-database and per-user GUC settings