pg_attribute growing extremely - Mailing list pgsql-general

From hamann.w@t-online.de
Subject pg_attribute growing extremely
Date
Msg-id wolfgang-1140606055623.A0218540@amadeus3.local
Whole thread Raw
Responses Re: pg_attribute growing extremely
Re: pg_attribute growing extremely
List pgsql-general
Hi,

on a server running 8.4 I observe that, since a while, the pg_attribute table is growing
enormously.
Soon after reloading I have one file
ls -s 1249
1048580 1249
a day later this is
1048580 1249
1048580 1249.1
1048580 1249.10
1048580 1249.11
1048580 1249.12
1048580 1249.13
1048580 1249.14
1048580 1249.15
 682212 1249.16
1048580 1249.2
1048580 1249.3
1048580 1249.4
1048580 1249.5
1048580 1249.6
1048580 1249.7
1048580 1249.8
1048580 1249.9
   4316 1249_fsm
     24 1249_vm
and 5 days later the system had arrived at 102 files

The server is running since quite some time, without any major change.
The workload is mostly reading, a little text updates and a little more binary updates.
Every two weeks or so the database is recreated and reloaded
The total size of data is growing slowly (say a rate of 10% per year)

Regards
Wolfgang Hamann





pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: help with a procedure
Next
From: David G Johnston
Date:
Subject: Re: pg_attribute growing extremely