| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Pavan Deolasee" <pavan(dot)deolasee(at)enterprisedb(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>, "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> |
| Subject: | Re: CREATE INDEX and HOT (was Question:pg_classattributes and race conditions ?) |
| Date: | 2007-03-17 21:11:52 |
| Message-ID: | 1174165912.4160.660.camel@silverbirch.site |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grzegorz Jaskiewicz | 2007-03-17 21:14:35 | Re: [PATCHES] Bitmapscan changes |
| Previous Message | Florian G. Pflug | 2007-03-17 20:44:29 | Re: Project suggestion: benchmark utility for PostgreSQL |