pg_statistic_relid_att_index
От | Jean-Christophe ARNU (JX) |
---|---|
Тема | pg_statistic_relid_att_index |
Дата | |
Msg-id | 20030625104035.430430e1.arnu@paratronic.fr обсуждение исходный текст |
Ответы |
Re: pg_statistic_relid_att_index
Re: pg_statistic_relid_att_index |
Список | pgsql-general |
Hi all, I've a problem with the pg_statistic_relid_att_index system index. The server version is 7.1.3 (so reindex is not available). This database is heavily updated,inserted,deleted and thus vacuumed. Since 1,5 year it runned perfectly but since the beginning of the we've got slow select. In many case, as the system goes slow, it often a question of table size. So I looked at the oid sizes in my data directory and the filenode corresponding to the pg_statistic_relid_att_index get about 87MB of my disk whereas other object remains quite small. I presume this index is not cleaned while vacuuming pg_statistic table (with or without analyze). My problem is a performance problem. I would avoid to upgrade database to 7.3 (some upgrade would be done soon and I do not really have time to spend now for such a task) and I would like to make this index slimmer as possible to get the performance back (for this database speed is a critical factor). Thanks in advance for any help/hints :) -- Jean-Christophe ARNU
В списке pgsql-general по дате отправления: