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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026