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 >> DETAIL: Process 24488 waits for ShareLock on virtual transaction >> 64/825033; blocked by process 27505. >> Process 27505 waits for ShareUpdateExclusiveLock on relation 297369165 >> of database 278059474; blocked by process 24488. >> > > 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
