pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Autovacuum in postgres.
7+ messages / 4 participants
[nested] [flat]

* Autovacuum in postgres.
@ 2010-05-21 09:38  venu madhav <venutaurus539@gmail.com>
  0 siblings, 3 replies; 7+ messages in thread

From: venu madhav @ 2010-05-21 09:38 UTC (permalink / raw)
  To: pgsql-performance

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

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Autovacuum in postgres.
@ 2010-05-21 09:39  venu madhav <venutaurus539@gmail.com>
  parent: venu madhav <venutaurus539@gmail.com>
  2 siblings, 0 replies; 7+ messages in thread

From: venu madhav @ 2010-05-21 09:39 UTC (permalink / raw)
  To: pgsql-performance

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
>

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Autovacuum in postgres.
@ 2010-05-27 14:33  Bruce Momjian <bruce@momjian.us>
  parent: venu madhav <venutaurus539@gmail.com>
  2 siblings, 1 reply; 7+ messages in thread

From: Bruce Momjian @ 2010-05-27 14:33 UTC (permalink / raw)
  To: venu madhav <venutaurus539@gmail.com>; +Cc: pgsql-performance

venu madhav 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.

What settings did you change to make it run every hour?  Also, it will
only vacuum tables that need vacuuming.  What version of Postgres are
you using?

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Autovacuum in postgres.
@ 2010-05-27 15:01  venu madhav <venutaurus539@gmail.com>
  parent: Bruce Momjian <bruce@momjian.us>
  0 siblings, 2 replies; 7+ messages in thread

From: venu madhav @ 2010-05-27 15:01 UTC (permalink / raw)
  To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-performance

Thanks for the reply..
           I am using postgres 8.01 and since it runs on a client box, I
can't upgrade it. I've set the auto vacuum nap time to 3600 seconds.

On Thu, May 27, 2010 at 8:03 PM, Bruce Momjian <bruce@momjian.us> wrote:

> venu madhav 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.
>
> What settings did you change to make it run every hour?  Also, it will
> only vacuum tables that need vacuuming.  What version of Postgres are
> you using?
>
> --
>  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Autovacuum in postgres.
@ 2010-05-27 15:07  Bruce Momjian <bruce@momjian.us>
  parent: venu madhav <venutaurus539@gmail.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Bruce Momjian @ 2010-05-27 15:07 UTC (permalink / raw)
  To: venu madhav <venutaurus539@gmail.com>; +Cc: pgsql-performance

venu madhav wrote:
> Thanks for the reply..
>            I am using postgres 8.01 and since it runs on a client box, I
> can't upgrade it. I've set the auto vacuum nap time to 3600 seconds.

That is an older version of autovacuum that wasn't very capable.

---------------------------------------------------------------------------

> On Thu, May 27, 2010 at 8:03 PM, Bruce Momjian <bruce@momjian.us> wrote:
> 
> > venu madhav 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.
> >
> > What settings did you change to make it run every hour?  Also, it will
> > only vacuum tables that need vacuuming.  What version of Postgres are
> > you using?
> >
> > --
> >  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
> >  EnterpriseDB                             http://enterprisedb.com
> >

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Autovacuum in postgres.
@ 2010-05-27 16:10  alvherre <alvherre@commandprompt.com>
  parent: venu madhav <venutaurus539@gmail.com>
  2 siblings, 0 replies; 7+ messages in thread

From: alvherre @ 2010-05-27 16:10 UTC (permalink / raw)
  To: venu madhav <venutaurus539@gmail.com>; +Cc: 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@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Autovacuum in postgres.
@ 2010-06-02 20:12  Scott Marlowe <scott.marlowe@gmail.com>
  parent: venu madhav <venutaurus539@gmail.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Scott Marlowe @ 2010-06-02 20:12 UTC (permalink / raw)
  To: venu madhav <venutaurus539@gmail.com>; +Cc: Bruce Momjian <bruce@momjian.us>; pgsql-performance

On Thu, May 27, 2010 at 9:01 AM, venu madhav <venutaurus539@gmail.com> wrote:
> Thanks for the reply..
>            I am using postgres 8.01 and since it runs on a client box, I
> can't upgrade it. I've set the auto vacuum nap time to 3600 seconds.

You've pretty much made autovac run every 5 hours with that setting.
What was wrong with the original settings?  Just wondering what
problem you were / are trying to solve here.



^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2010-06-02 20:12 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-05-21 09:38 Autovacuum in postgres. venu madhav <venutaurus539@gmail.com>
2010-05-21 09:39 ` venu madhav <venutaurus539@gmail.com>
2010-05-27 14:33 ` Bruce Momjian <bruce@momjian.us>
2010-05-27 15:01   ` venu madhav <venutaurus539@gmail.com>
2010-05-27 15:07     ` Bruce Momjian <bruce@momjian.us>
2010-06-02 20:12     ` Scott Marlowe <scott.marlowe@gmail.com>
2010-05-27 16:10 ` alvherre <alvherre@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox