[GENERAL] Autovacuum settings between systems

2010-09-28 Thread Chris Barnes
I am using 8.4.2 on centos 5.4 2.6.18-164.el5 #1 SMP Thu Sep 3 03:28:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux I have autovacuum processes that appear to have been running most of the day. There aren't any messages in the log, but there must be something wrong for it to take this long? d

[GENERAL] autovacuum settings

2008-08-29 Thread Joao Ferreira gmail
Hello all, in which system tables can I find the effective run-time values of the autovacuum configuration parameters... naptime, thresholds, scale factors, etc thx joao -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po

Re: [GENERAL] autovacuum settings

2006-04-06 Thread Jim Nasby
On Apr 6, 2006, at 8:57 AM, Jebus wrote: I am totally new to postgres and I wondering what settings should I be using for autovacuum ? For now I just uncommented all the defaults, is this good enough ? The database is not large but it is a web database so there is a lot of inserts and updates.

[GENERAL] autovacuum settings

2006-04-06 Thread Jebus
I am totally new to postgres and I wondering what settings should I be using for autovacuum ? For now I just uncommented all the defaults, is this good enough ? The database is not large but it is a web database so there is a lot of inserts and updates. autovacuum = on #