Constant file growth.

From: Alexandre Carmel-Veilleux <acv(at)abovesecurity(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Constant file growth.
Date: 2002-02-15 16:29:57
Message-ID: 200202151630.LAA26321@vesuve.globetrotter.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2002-02-15 17:00:46 Re: How to include plpgsql in table pg_language
Previous Message Tom Lane 2002-02-15 16:12:53 Re: problem with postgresql7.2 installation