Skip site navigation (1) Skip section navigation (2)

Re: Autovacuum in postgres.

From: alvherre <alvherre(at)commandprompt(dot)com>
To: venu madhav <venutaurus539(at)gmail(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Autovacuum in postgres.
Date: 2010-05-27 16:10:20
Message-ID: 1274976439-sup-7339@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-performance
Excerpts from venu madhav's message of vie may 21 05:38:43 -0400 2010:
> Hi All,
>        In my application we are using postgres which runs on an embedded
> box. I have configured autovacuum to run once for every one hour. It has 5
> different databases in it. When I saw the log messages, I found that it is
> running autovacuum on one database every hour. As a result, on my database
> autovacuum is run once in 5 hours. Is there any way to make it run it every
> hour.

If you set naptime to 12 mins, it will run on one database every 12
minutes, so once per hour for your database.  This is not really the
intended usage though.  You will have to adjust the time if another
database is created.

-- 
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2010-05-27 16:41:28
Subject: Re: Query causing explosion of temp space with join involving partitioning
Previous:From: David JarvisDate: 2010-05-27 15:55:55
Subject: Re: Random Page Cost and Planner

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group