Message-ID: <1426332393.3775.3.camel@gmail.com>
Subject: Re: CLUSTERing a partition?
From: jaime soler <jaime.soler@gmail.com>
Reply-To: jaime.soler@gmail.com
To: Dave Johansen <davejohansen@gmail.com>
Cc: pgsql-admin@postgresql.org
Date: Sat, 14 Mar 2015 12:26:33 +0100
In-Reply-To: 
 <CAAcYxUeFzDWdGAVdpZX8NDLqWo_V7o5xtnafvXmML0jG_JHFPA@mail.gmail.com>
References: 
 <CAAcYxUeFzDWdGAVdpZX8NDLqWo_V7o5xtnafvXmML0jG_JHFPA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

El vie, 13-03-2015 a las 16:33 -0700, Dave Johansen escribió:
> I'm using Postgres 8.4 and I would like to cluster a partition but
> keep running into issues with locks. CLUSTER requires an Exclusive
> Lock and so it gets "stuck behind" running queries that have a Share
> Lock on the partition even though they are not using the partition. I
> would be fine if the cluster waited until after the existing queries
> finished, but this then causes all new queries to back up behind it. I
> tried doing "NO INHERIT" to remove the partition while the cluster is
> happening, but that also requires an Exclusive Lock and runs into the
> same problem.
> 
uff postgresql 8.4, are you from the past?
> 
> So is there some way that I can CLUSTER a partition? I would be fine
> with removing the partition while the CLUSTER is happening, if that
> makes it possible.

There is a extension pg_repack http://pgxn.org/dist/pg_repack/1.3.1/ ,
that allows to retore order of a table without using a exclusive lock,
but i don't know how it behavior with partitioned tables.

good luck
> 
> 
> Thanks,
> 
> Dave


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin