Hello! How can i recreate system indexes in PostgreSQL 6.5.x? I understand there is a REINDEX command for v7 but how is it possible to do the same thing in v6.5 (there is on 6.5.2 and one 6.5.3 running). The problem is that such indexes as pg_attribute_attrelid_index pg_attribute_relid_attnam_index pg_attribute_relid_attnum_index pg_class_relname_index pg_type_typname_index etc are getting out of hand (e.g. pg_attribute_relid_attnam_index is ~50 times larger than pg_attribute). This is caused by lots of temporary tables being created and removed (as i understand). Juhan Ernits