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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Feature freeze date for 8.1


  • From: "Marc G. Fournier" <scrappy(at)postgresql(dot)org>
  • To: Bruno Wolff III <bruno(at)wolff(dot)to>
  • Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Christopher Browne <cbbrowne(at)acm(dot)org>, pgsql-hackers(at)postgresql(dot)org
  • Subject: Re: Feature freeze date for 8.1
  • Date: Fri, 29 Apr 2005 12:43:37 -0300 (ADT)
  • Message-id: <20050429124149(dot)W53065(at)ganymede(dot)hub(dot)org>

On Fri, 29 Apr 2005, Bruno Wolff III wrote:

On Fri, Apr 29, 2005 at 10:09:43 -0400,
 Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
Tom Lane wrote:
Christopher Browne <cbbrowne(at)acm(dot)org> writes:
In the last exciting episode, pgman(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian) wrote:
o integrated auto-vacuum (Bruce)

If this can kick off a vacuum of a Very Large Table at an unfortunate
time, this can turn out to be a prety painful misfeature.

[ shrug... ]  You'll always be able to turn it off if you don't want it.
I'm not sure that we'll be ready to turn it on by default even in 8.1.

Agreed.  It will just be there to turn on from postgresql.conf if you
want it, and we do have TODO information about keeping such an FSM for
recently expired pages.

I think if we aren't finding problems in testing that it would be better
to turn pg_autovacuum on by default. Vacuum is something the burns new
users and having it one by default is going to cut down on surprises.

Except for the surprise of peridically having the system go unresponsive because it hit a large table, and that new user wondering what is wrong with postgresql that it just stalls seemingly randomly :(

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org           Yahoo!: yscrappy              ICQ: 7615664



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group