Postgres Pro
Downloads
Home   >   mailing lists

Re: Index creation problem - Mailing list pgsql-general

From Oliver Kohll - Mailing Lists
Subject Re: Index creation problem
Date
Msg-id E83F9402-5791-482C-AD50-FFC3A7EEC5D5@gtwm.co.uk
Whole thread Raw
In response to Index creation problem  (Oliver Kohll - Mailing Lists <oliver.lists@gtwm.co.uk>)
List pgsql-general
Tree view
On 19 Oct 2012, at 13:28, Frank Lanitz <frank@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:


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 

pgsql-general by date:

Previous
From: Oliver Kohll - Mailing Lists
Date:
Subject: Index creation problem
Next
From: "Albe Laurenz"
Date:
Subject: Re: Index creation problem