Re: Syscaches should store negative entries, too

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Syscaches should store negative entries, too
Дата
Msg-id 1012416017.1923.3.camel@rh72.home.ee
обсуждение исходный текст
Ответ на Re: Syscaches should store negative entries, too  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Syscaches should store negative entries, too  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: Syscaches should store negative entries, too
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Per-database and per-user GUC settings