From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | hamann(dot)w(at)t-online(dot)de |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_attribute growing extremely |
Date: | 2014-06-06 06:24:35 |
Message-ID: | 20140606062435.GC32526@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jun 06, 2014 at 03:56:23AM -0000, hamann(dot)w(at)t-online(dot)de wrote:
>
> 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
Is autovacuum enabled? Are you using a lot of temporary tables? Do you
have long running transactions?
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.
-- Arthur Schopenhauer
From | Date | Subject | |
---|---|---|---|
Next Message | Bhushan Pathak | 2014-06-06 07:29:58 | Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb |
Previous Message | David G Johnston | 2014-06-06 04:44:53 | Re: pg_attribute growing extremely |