Re: Index creation problem

[Oliver Kohll - Mailing Lists <oliver.lists@xxxxxxxxxx>]

On 19 Oct 2012, at 13:28, Frank Lanitz <frank@xxxxxxxxxxxxxx> 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