Postgres Pro
Downloads
Home   >   mailing lists

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 1174157818.4160.652.camel@silverbirch.site
Whole thread Raw
In response to Re: CREATE INDEX and HOT (was Question: pg_class attributes and race conditions ?)  ("Pavan Deolasee" <pavan.deolasee@enterprisedb.com>)
Responses Re: CREATE INDEX and HOT (was Question: pg_classattributes and race conditions ?)  ("Pavan Deolasee" <pavan.deolasee@enterprisedb.com>)
List pgsql-hackers
Tree view 
On Sat, 2007-03-17 at 23:11 +0530, Pavan Deolasee wrote:

> The algorithm would look like:
> 
> 1. Disable HOT-updates

The lock held by CREATE INDEX already prevents HOT updates. So steps 1
and 8 aren't needed.

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?

Hopefully it is only CREATE INDEX that we need to think about.

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

pgsql-hackers by date:

Previous
From: "Mickael DELOISON"
Date:
Subject: Project suggestion: benchmark utility for PostgreSQL
Next
From: "Pavan Deolasee"
Date:
Subject: Re: CREATE INDEX and HOT (was Question: pg_classattributes and race conditions ?)