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

Re: [HACKERS] What can we learn from MySQL?

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: pg(at)fastcrypt(dot)com
Cc: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>,"Fabien COELHO" <coelho(at)cri(dot)ensmp(dot)fr>,"Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>,"PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>,"PostgreSQL advocacy" <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: [HACKERS] What can we learn from MySQL?
Date: 2004-04-23 15:52:14
Message-ID: 33854.192.154.91.225.1082735534.squirrel@192.154.91.225 (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-www
> Does the current implementation of pg_autovacuum have a way of setting
> windows where it is allowed to vacuum? Many large 24/7 will only allow
> vacuumming at certain times of the day.

No the current implementation doesn't, but such a feature is in the works
(planned anyway).  What I was envisioning is the ability to set two
different sets of thresholds (peak / off peak).  If you demand zero
vacuuming during peak times, you could set that threshold to -1, or some
such setting.

FYI I wouldn't remcommend defaulting pg_autovacuum to on until it does
this, and a few more things that are also planned (see the archives).

Matthew


In response to

pgsql-www by date

Next:From: Matthew T. O'ConnorDate: 2004-04-23 15:55:53
Subject: Re: [HACKERS] What can we learn from MySQL?
Previous:From: Robert TreatDate: 2004-04-23 15:45:28
Subject: Re: [HACKERS] What can we learn from MySQL?

pgsql-hackers by date

Next:From: Matthew T. O'ConnorDate: 2004-04-23 15:55:53
Subject: Re: [HACKERS] What can we learn from MySQL?
Previous:From: Robert TreatDate: 2004-04-23 15:45:28
Subject: Re: [HACKERS] What can we learn from MySQL?

pgsql-advocacy by date

Next:From: Matthew T. O'ConnorDate: 2004-04-23 15:55:53
Subject: Re: [HACKERS] What can we learn from MySQL?
Previous:From: Robert TreatDate: 2004-04-23 15:45:28
Subject: Re: [HACKERS] What can we learn from MySQL?

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