Re: neverending vacuum - Mailing list pgsql-performance

From Csaba Nagy
Subject Re: neverending vacuum
Date
Msg-id 1141052619.6846.263.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: neverending vacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-performance
> So one very effective way of speeding this process up is giving the
> vacuum process lots of memory, because it will have to do fewer passes
> at each index.  How much do you have?

OK, this is my problem... it is left at default (16 megabyte ?). This
must be a mistake in configuration, on other similar boxes I set this to
262144 (256 megabyte). The box has 4 Gbyte memory.

Thanks for the explanation - you were right on the spot, it will likely
solve the problem.

Cheers,
Csaba.




pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: neverending vacuum
Next
From: Jamal Ghaffour
Date:
Subject: The trigger can be specified to fire on time condition?