On Mon, Apr 11, 2011 at 12:39 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Scott Marlowe <scott.marl...@gmail.com> writes: >> On Mon, Apr 11, 2011 at 1:41 AM, Greg Smith <g...@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.
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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
