Re: Syscaches should store negative entries, too

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Syscaches should store negative entries, too
Дата
Msg-id 200202011932.g11JWZM29513@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Syscaches should store negative entries, too  (Hannu Krosing <hannu@krosing.net>)
Список 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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: sql select query with column 'AS' assignment
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Per-database and per-user GUC settings