Index file size keeps on growing.....
От | Jean-Christophe ARNU (JX) |
---|---|
Тема | Index file size keeps on growing..... |
Дата | |
Msg-id | 20020523064053.1a99b535.jc.arnu@free.fr обсуждение исходный текст |
Ответы |
Re: Index file size keeps on growing.....
|
Список | pgsql-admin |
Hi all, I'm in front of a real problem (from my point of view). I have some tables with a lot of update insert and delete (24/7). These tables have multiples indexes. Major part of Insert commands are performed as bulk at 00:00:00. I'm doing Vaccum and then a vacuum analyze to clean tables (well done) and update indexes (also performed) BUT index are not "cleaned" in the way their size keeps on growing in size... The real problem is that I have tables that takes about 20MB each and index around 190MB (for some of them). The only way I found to reduce index file size is to destroy the incriminated indexes and recreate, praying for select not to happen between drop and create operation (I cannot afford table lock)... So is this a correct Postgres Behaviour? Do I have a neat way to make my index keep a reasonnable size? Did I missed something in the config file and/or with the vacuum commands? Thanks for any clue!! -- Jean-Christophe ARNU s/w developer Paratronic France
В списке pgsql-admin по дате отправления: