On Mon, Apr 11, 2011 at 12:39 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: >> On Mon, Apr 11, 2011 at 1:41 AM, Greg Smith <greg@xxxxxxxxxxxxxxx> 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. I thought they'd stand in line waiting on each other. I'll give it a try. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
