Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-14 Thread Rajesh Kumar Mallah
Its nice to know the evolution of autovacuum and i understand that the suggestion/requirement of "autovacuum at lean hours only" was defeating the whole idea. regds --rajesh kumar mallah. On Fri, Feb 13, 2009 at 11:07 PM, Chris Browne wrote: > mallah.raj...@gmail.com (Rajesh Kumar Mallah) writ

Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-14 Thread Chris Browne
mallah.raj...@gmail.com (Rajesh Kumar Mallah) writes: > why is it not a good idea to give end users control over when they > want to run it ? It's not a particularly good idea to give end users things that they are likely then to *immediately* use to shoot themselves in the foot. Turning off vacu

Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-12 Thread Guillaume Cottenceau
Rajesh Kumar Mallah writes: > our usage pattern is such that peak activity (indicated by load average) > during day time is 10 times during night hours. Autovacuum just puts > more pressure to the system. If less stressing version is used then Yet it may allow a more stable performance in the mi

Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-11 Thread Rajesh Kumar Mallah
On Wed, Feb 11, 2009 at 11:30 PM, Brad Nicholson wrote: > On Wed, 2009-02-11 at 22:57 +0530, Rajesh Kumar Mallah wrote: >> On Wed, Feb 11, 2009 at 10:03 PM, Grzegorz Jaśkiewicz >> wrote: >> > On Wed, Feb 11, 2009 at 2:57 PM, Rajesh Kumar Mallah >> > wrote: >> > >> >>> vacuum_cost_delay = 150 >>

Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-11 Thread Brad Nicholson
On Wed, 2009-02-11 at 22:57 +0530, Rajesh Kumar Mallah wrote: > On Wed, Feb 11, 2009 at 10:03 PM, Grzegorz Jaśkiewicz > wrote: > > On Wed, Feb 11, 2009 at 2:57 PM, Rajesh Kumar Mallah > > wrote: > > > >>> vacuum_cost_delay = 150 > >>> vacuum_cost_page_hit = 1 > >>> vacuum_cost_page_miss = 10 > >

Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-11 Thread Ben Chobot
On Wed, 11 Feb 2009, Scott Carey wrote: On a large partitioned database, ordinary vacuum is a very very difficult option. Most of the time on such a system, most tables are dormant with respect to writes and never need to be vacuumed. A 'daily vacuum' is likely to take a full day to run on

Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-11 Thread Rajesh Kumar Mallah
On Wed, Feb 11, 2009 at 10:03 PM, Grzegorz Jaśkiewicz wrote: > On Wed, Feb 11, 2009 at 2:57 PM, Rajesh Kumar Mallah > wrote: > >>> vacuum_cost_delay = 150 >>> vacuum_cost_page_hit = 1 >>> vacuum_cost_page_miss = 10 >>> vacuum_cost_page_dirty = 20 >>> vacuum_cost_limit = 1000 >>> autovacuum_vacuum

Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-11 Thread Scott Carey
From: pgsql-performance-ow...@postgresql.org [pgsql-performance-ow...@postgresql.org] On Behalf Of Ben [be...@silentmedia.com] Sent: Wednesday, February 11, 2009 8:46 AM To: Rajesh Kumar Mallah Cc: PostgreSQL Performance Subject: Re: [PERFORM] scheduling autovacuum at lean hours only. On Feb 11, 2009,

Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-11 Thread Ben
On Feb 11, 2009, at 6:57 AM, Rajesh Kumar Mallah wrote: why is it not a good idea to give end users control over when they want to run it ? There's nothing stopping you from just turning off autovacuum and running vacuum manually. The point of autovacuum is to vacuum "as needed." -- Sen

Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-11 Thread Grzegorz Jaśkiewicz
On Wed, Feb 11, 2009 at 2:57 PM, Rajesh Kumar Mallah wrote: >> vacuum_cost_delay = 150 >> vacuum_cost_page_hit = 1 >> vacuum_cost_page_miss = 10 >> vacuum_cost_page_dirty = 20 >> vacuum_cost_limit = 1000 >> autovacuum_vacuum_cost_delay = 300 > > why is it not a good idea to give end users control

Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-11 Thread Alvaro Herrera
Rajesh Kumar Mallah escribió: > why is it not a good idea to give end users control over when they > want to run it ? It has never been said that we don't want to give the users control. It's a matter of writing the code. If you want to propose a patch to add the feature, feel free. -- Sent vi

Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-11 Thread Rajesh Kumar Mallah
On Wed, Feb 11, 2009 at 7:11 PM, Guillaume Cottenceau wrote: > Rajesh Kumar Mallah writes: > >> Hi, >> >> Is it possible to configure autovacuum to run only >> during certain hours ? We are forced to keep >> it off because it pops up during the peak >> query hours. > > You'd rather configure the

Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-11 Thread Guillaume Cottenceau
Rajesh Kumar Mallah writes: > Hi, > > Is it possible to configure autovacuum to run only > during certain hours ? We are forced to keep > it off because it pops up during the peak > query hours. You'd rather configure the delaying process to not alter too much performance. Autovacuum is really n

Re: [PERFORM] scheduling autovacuum at lean hours only.

2009-02-11 Thread Glyn Astill
> From: Rajesh Kumar Mallah > Is it possible to configure autovacuum to run only > during certain hours ? We are forced to keep > it off because it pops up during the peak > query hours. AFAIK not directly within the conf. However you could probably set up a shell script to turn it on and off