Constant file growth.

Поиск
Список
Период
Сортировка
От Alexandre Carmel-Veilleux
Тема Constant file growth.
Дата
Msg-id 200202151630.LAA26321@vesuve.globetrotter.net
обсуждение исходный текст
Список pgsql-admin
Hello

    I have noticed that my postgresql database sees a constant growth to some of
the system files:

184M    17112
Database=# select relname from pg_class where relfilenode = 17112;
             relname
---------------------------------
 pg_attribute_relid_attnam_index
(1 row)

 77M    17115
Database=# select relname from pg_class where relfilenode = 17115;
             relname
---------------------------------
 pg_attribute_relid_attnum_index
(1 row)

 44M    17121
Database=# select relname from pg_class where relfilenode = 17121;
        relname
------------------------
 pg_class_relname_index
(1 row)

    These files represent 305M out of the 454M of my database. Any hints on why
it is so and how I can fix it would be greatly appreciated. Dropping and
reloading is next to useless. I am using 7.1.3 under FreeBSD 4.3.

Alex

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: problem with postgresql7.2 installation
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: How to include plpgsql in table pg_language