From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Multiple index builds on same table - in one sweep?
Date: Mon, 11 Apr 2011 14:39:03 -0400
Message-ID: <6692.1302547143@sss.pgh.pa.us> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, scott.marlowe@gmail.com, greg@2ndquadrant.com
Subject: Re: Multiple index builds on same table - in one sweep?
In-Reply-To: <6692.1302547143@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox