On Fri, Jun 06, 2014 at 03:56:23AM -0000, hamann.w@xxxxxxxxxxx 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@xxxxxxxxx> 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
Attachment:
signature.asc
Description: Digital signature
