index keeps on growing

Поиск
Список
Период
Сортировка
От Jean-Christophe ARNU (JX)
Тема index keeps on growing
Дата
Msg-id 20020618170214.1568a89e.jc.arnu@wanadoo.fr
обсуждение исходный текст
Список pgsql-admin
Hello all,
    I've a hard working pgsql db running on 7/7x365 server. Each night (when
activity is less intensive) I run vacuum and vacuum analyze on tables where
principal activity is performed.
    Tables are cleaned (files sizes are decreasing), but indices files keeps on
growing in size....

    I run PgSQL 7.1.3, I cannot upgrade (immediately) to 7.2.x... So what can I
do to keep these indices' size at a constant and reasonnable size?

    Thanks a lot

--
Jean-Christophe ARNU
s/w developer
Paratronic France

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Michael P. Dobmeier"
Дата:
Сообщение: Some questions regarding authentication (via pg_hba.conf password pwfile)
Следующее
От: "Camilo Villarreal"
Дата:
Сообщение: Help! sed: command garbled compiling on Solaris7