Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum in postgres. - Mailing list pgsql-performance

From venu madhav
Subject Re: Autovacuum in postgres.
Date
Msg-id AANLkTinAVSNCXUlXR4A8Ezl8SqZWH_V3GE2lWhwsPFjL@mail.gmail.com
Whole thread Raw
In response to Autovacuum in postgres.  (venu madhav <venutaurus539@gmail.com>)
List pgsql-performance
Tree view
One more question " Is is expected ?"

On Fri, May 21, 2010 at 3:08 PM, venu madhav <venutaurus539@gmail.com> wrote:
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.


Thank you,
Venu

pgsql-performance by date:

Previous
From: venu madhav
Date:
Subject: Autovacuum in postgres.
Next
From: Tyler Hildebrandt
Date:
Subject: Query timing increased from 3s to 55s when used as function instead of select