Re: pg_index updates and SI invalidation

Поиск
Список
Период
Сортировка
От Pavan Deolasee
Тема Re: pg_index updates and SI invalidation
Дата
Msg-id 2e78013d0703270058p7eaec968hf3dcc2496d93d29c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_index updates and SI invalidation  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_index updates and SI invalidation  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers


On 3/26/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:


It might be feasible to have RelationReloadClassinfo re-read the
pg_index row and apply only the updates for specific known-changeable
columns.  The stuff it's worried about is the subsidiary data such
as support function fmgr lookup records, but we don't need those to
change on the fly.



Here is a patch  which fixes this. We re-read part of the pg_index
row and update rd_index with the new data. I tested REINDEX and CIC
and both seems to work fine with the patch applied.

Tom, does this look good ?

Thanks,
Pavan

--

EnterpriseDB     http://www.enterprisedb.com
Вложения

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

Предыдущее
От: "Marko Kreen"
Дата:
Сообщение: Re: BSD advertizing clause in some files
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: notification payloads