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
