On 19 Oct 2012, at 13:28, Frank Lanitz <fr...@frank.uvena.de> wrote: > Just an idea without bigger investigation: Whare are the idle in > transactions are doing? Maybe they are blocking the create index. > > Cheers, > Frank
Good question, I don't know. The app runs on Java / Apache Tomcat, which maintains a connection pool, so I assumed the IDLEs were just opened connections but I didn't notice two were idle in transaction. I haven't dealt with this before but this looks like a good explanation: http://www.depesz.com/2008/08/28/hunting-idle-in-transactions/ I will up logging and try to replicate. Next time I will look at pg_locks too. Also, the PG version is 9.1.6. Oliver
