Re: CLUSTERing a partition?

On Sat, Mar 14, 2015 at 4:26 AM, jaime soler <jaime(dot)soler(at)gmail(dot)com> wrote:

> 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.
>

Thanks for the info, but https://github.com/reorg/pg_repack/issues/23
scares me way too much to consider using it.