pg_attribute growing extremely

From: hamann(dot)w(at)t-online(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: pg_attribute growing extremely
Date: 2014-06-06 03:56:23
Message-ID: wolfgang-1140606055623.A0218540@amadeus3.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2014-06-06 04:44:53 Re: pg_attribute growing extremely
Previous Message Adrian Klaver 2014-06-06 00:29:08 Re: help with a procedure