Re: CREATE INDEX and HOT (was Question:pg_classattributes and race conditions ?) - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: CREATE INDEX and HOT (was Question:pg_classattributes and race conditions ?)
Date
Msg-id 1174165912.4160.660.camel@silverbirch.site
Whole thread Raw
In response to Re: CREATE INDEX and HOT (was Question: pg_classattributes and race conditions ?)  ("Pavan Deolasee" <pavan.deolasee@enterprisedb.com>)
List pgsql-hackers
On Sun, 2007-03-18 at 00:44 +0530, Pavan Deolasee wrote:
> Simon Riggs wrote:
>  >
>  > We need to be clear that we already have a solution to CREATE INDEX
>  > CONCURRENTLY. Do you agree that we do? Does anyone see a problem with
>  > the posted design for that?

If we have solved CREATE INDEX CONCURRENTLY, then I would propose that
this becomes the default option for creating an index, when the
statement is issued outside of a statement block.

That seems better than reminding everybody to run with the CONCURRENTLY
option, or advise them of different performance characteristics or
behaviour of the normal CREATE INDEX route.

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com




pgsql-hackers by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: Project suggestion: benchmark utility for PostgreSQL
Next
From: Grzegorz Jaskiewicz
Date:
Subject: Re: [PATCHES] Bitmapscan changes