"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes
> Is it possible to cluster system tables?
>
Ooops, I guess I mixed two concepts - oid and relfilenode. Those operations
change relfilenode but not oids. I don't think we could cluster system
tables.
template1=# select oid, relfilenode from pg_class where relname =
'pg_attribute_
relid_attnam_index';
oid | relfilenode
-------+-------------
16688 | 17239
(1 row)
template1=# reindex table pg_attribute;
REINDEX
template1=# select oid, relfilenode from pg_class where relname =
'pg_attribute_
relid_attnam_index';
oid | relfilenode
-------+-------------
16688 | 17241
(1 row)
template1=# cluster pg_attribute_relid_attnam_index on pg_attribute;
ERROR: "pg_attribute" is a system catalog
Regards,
Qingqing
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
