Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE INDEX and HOT - revised design - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: CREATE INDEX and HOT - revised design
Date
Msg-id 871wj7dgj3.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: CREATE INDEX and HOT - revised design  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
List pgsql-hackers
Tree view 
"Pavan Deolasee" <pavan.deolasee@gmail.com> writes:

> What I am proposing is to keep index unusable for existing transactions.
> The index is available for all new transactions even if there are unfinished
> existing transactions. 

Ah thanks, that makes a lot more sense. Sorry for the false alarm.


--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Server-side support of all encodings
Next
From: Tom Lane
Date:
Subject: Re: problems with plan invalidation