Thread: recreate system indexes in 6.5?

recreate system indexes in 6.5?

From
Juhan Ernits
Date:
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