Re: pg_index updates and SI invalidation - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: pg_index updates and SI invalidation
Date
Msg-id 2e78013d0703270058p7eaec968hf3dcc2496d93d29c@mail.gmail.com
Whole thread Raw
In response to Re: pg_index updates and SI invalidation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_index updates and SI invalidation
List 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
Attachment

pgsql-hackers by date:

Previous
From: "Marko Kreen"
Date:
Subject: Re: BSD advertizing clause in some files
Next
From: Hannu Krosing
Date:
Subject: Re: notification payloads