> The new cluster is cool in that : > > 1. It works > 2. It saves the indisclustered status > > However, after a dump and restore, this indisclustered status will be lost. > Would it be an idea to issue a CLUSTER command after the CREATE TABLE > statement in SQL dumps for tables that have an indisclustered index?
Actually, rather than a full-blown CLUSTER, how about...: UPDATE pg_index SET indisclustered=true WHERE indrelid=(SELECT oid FROM pg_class WHERE relname='mytable' AND relnamespace = (SELECT oid FROM pg_namespace WHERE nspname=CURRENT_SCHEMA())); Hmmm...need something for index name as well tho... Is that an idea? Chris ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
