| From: | Juhan Ernits <juhan(at)suhkur(dot)cc(dot)ioc(dot)ee> |
|---|---|
| To: | "Pgsql-General(at)Postgresql(dot)Org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | recreate system indexes in 6.5? |
| Date: | 2000-04-23 12:03:27 |
| Message-ID: | 3902E68F.B6FCAB31@cc.ioc.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert | 2000-04-23 15:39:57 | Rounding/create C function question |
| Previous Message | Bruce Momjian | 2000-04-23 11:22:04 | Re: unique row identifier data type exhausted . . . |