Re: CLUSTERing a partition?

[Matheus de Oliveira <matioli.matheus@xxxxxxxxx>]

On Fri, Mar 13, 2015 at 8:33 PM, Dave Johansen <davejohansen@xxxxxxxxx> wrote:

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.

You can remove the partition first (with NO INHERIT), this will indeed cause a lock on the parent, but that should be really fast.

Then you can CLUSTER it, and latter re-add it as child.

Regards,

--

Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres