Re: concurrent reindex issues - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: concurrent reindex issues
Date
Msg-id dcc563d10910081304t63358acax14fb6805c94dc14b@mail.gmail.com
Whole thread Raw
In response to Re: concurrent reindex issues  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: concurrent reindex issues  (Tory M Blue <tmblue@gmail.com>)
List pgsql-performance
On Thu, Oct 8, 2009 at 11:55 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I wouldn't be too surprised if the LOCK is coming from some Slony
> operation or other.  You might want to ask the slony hackers about it.

I've had issues like this.  Shutting down the slon daemons before
running such commands would usually allow them to finish, at the cost
of replication falling behind while it runs.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: concurrent reindex issues
Next
From: Justin T Pryzby
Date:
Subject: Re: dump time increase by 1h with new kernel