Re: Dump CLUSTER in pg_dump

On Thu, Feb 27, 2003 at 02:24:02PM +0800, Christopher Kings-Lynne wrote:
> Currently, the fact that an index is clustered is not dumped. Unfortunately
> the only way of dumping this information is with a cluster statement itself.
>
> One possible improvement would be to sort clustered indexes first and dump
> them first, that way the cluster operation does not have to do so much
> reindexing.

Is this really a good idea? I think the clustering itself should be
done later and manually by the DBA, and the dump should only include a
command to set the indisclustered bit appropiately. What about
inventing a command to only set the bit, maybe

ALTER TABLE <tablename> CLUSTER ON <indexname>

or something like that? I can do that if people thinks it's a good
idea.

(Just returning from vacation and catching up on email).

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El miedo atento y previsor es la madre de la seguridad" (E. Burke)