Re: Index creation problem - Mailing list pgsql-general

From Oliver Kohll - Mailing Lists
Subject Re: Index creation problem
Date
Msg-id A655178E-E20C-41FD-B4C6-B11AD3E03286@gtwm.co.uk
Whole thread Raw
In response to Re: Index creation problem  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general

On 19 Oct 2012, at 15:09, "Albe Laurenz" <laurenz.albe@wien.gv.at> wrote:

You should always include the list in your replies -
other people might be interested in the solution.

Oops, thought I had.


There must be at least two transactions involved
to create a locking problem like you describe.
But since CREATE INDEX takes strong locks, it can
easily get locked by other "harmless" things.

OK, I've reduced the calls to CREATE INDEX, waiting to test that. If there's still an issue I will use CONCURRENTLY as you suggested.

Many thanks
Oliver

pgsql-general by date:

Previous
From: GMAIL
Date:
Subject: Re: Multiple Cluster on same host
Next
From: Shaun Thomas
Date:
Subject: Re: Multiple Cluster on same host