On Thu, Oct 18, 2012 at 2:13 AM, teyking2003 <tchongking@xxxxxxxxxxx> wrote: > Can anyone provide me a sample of auto vacuum and also step by step to > configure it inside my linux ubuntu server? Here's the basic instructions on autovacuum for pgsql 8.2. Note that since it's out of support, if you run into any bugs or problems with it you're likely to be told to upgrade. http://www.postgresql.org/docs/8.2/static/runtime-config-autovacuum.html As long as it's on (first setting on that page) the default values are fine for most low to medium level usage patterns. If you are doing enough work that you need to tune autovacuum, then you DEFINITELY need to upgrade to a more recent version of pgsql than 8.2. The biggest issue with 8.2 is that autovacuum is not multi-threaded. One long running vacuum thread can allow multiple tables to get bloated in a busy server. Also some bugs in vacuum have been fixed since 8.2 was end of lifed, so you may run into them as well. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
