Re: CacheInvalidateRelcache in btree is a crummy idea

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: CacheInvalidateRelcache in btree is a crummy idea
Дата
Msg-id 52F1F9E4.9050808@vmware.com
обсуждение исходный текст
Ответ на CacheInvalidateRelcache in btree is a crummy idea  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: CacheInvalidateRelcache in btree is a crummy idea  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения 
On 02/02/2014 11:45 PM, Tom Lane wrote:
> So I'm thinking my commit d2896a9ed, which introduced this mechanism,
> was poorly thought out and we should just remove the relcache invals
> as per the attached patch.  Letting _bt_getroot() update the cached
> metapage at next use should be a lot cheaper than a full relcache
> rebuild for the index.

Looks good to me.

- Heikki

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Re: Misaligned BufferDescriptors causing major performance problems on AMD
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Performance Improvement by reducing WAL for Update Operation