To: Scott Marlowe <scott.marlowe@gmail.com>
cc: Greg Smith <greg@2ndquadrant.com>, pgsql-performance@postgresql.org
Subject: Re: Multiple index builds on same table - in one sweep? 
In-reply-to: <BANLkTin+9nd9xJ4u11C23ENCJgiteKG-Zw@mail.gmail.com> 
References: <DD8709CB-474F-4002-B555-1ED974371364@ruprecht.org>
	<4325.1302369004@sss.pgh.pa.us>
	<DBEFE6AF-E8CE-4508-A8C3-A0E5E0987EFE@ruprecht.org>
	<4DA2679D.5000207@2ndQuadrant.com>
	<BANLkTinTWXOKd6QunwBag1AJypYTVjYxRw@mail.gmail.com>
	<4DA2B0A4.6050605@2ndquadrant.com>
	<BANLkTin+9nd9xJ4u11C23ENCJgiteKG-Zw@mail.gmail.com>
Comments: In-reply-to Scott Marlowe <scott.marlowe@gmail.com>
	message dated "Mon, 11 Apr 2011 01:57:35 -0600"
Date: Mon, 11 Apr 2011 14:39:03 -0400
Message-ID: <6692.1302547143@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Mon, Apr 11, 2011 at 1:41 AM, Greg Smith <greg@2ndquadrant.com> wrote:
>> Scott Marlowe wrote:
>>> FYI, in 8.3.13 I get this for all but one index:
>>> ERROR:  deadlock detected

>> Is that trying to build them by hand?  The upthread request here is actually
>> already on the TODO list at http://wiki.postgresql.org/wiki/Todo and it
>> talks a bit about what works and what doesn't right now:

> Yes, by hand.  It creates an entry for the index but lists but marks
> it as INVALID

Are you trying to use CREATE INDEX CONCURRENTLY?  AFAIR that doesn't
support multiple index creations at the same time.  Usually you wouldn't
want that combination anyway, since the point of CREATE INDEX
CONCURRENTLY is to not prevent foreground use of the table while you're
making the index --- and multiple index creations are probably going to
eat enough I/O that you shouldn't be doing them during normal operations
anyhow.

Just use plain CREATE INDEX.

			regards, tom lane