Re: Autovacuum in the backend

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Russell Smith <mr-russ(at)pws(dot)com(dot)au>
Cc: Alvaro Herrera <alvherre(at)surnet(dot)cl>, Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autovacuum in the backend
Date: 2005-06-16 03:57:45
Message-ID: 42B0F8B9.30706@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


> The big leap will be to get it in the backend, which will as Chris KL suggested stop people shooting themselves in the foot.
> I'm not sure what strict rules are imposed by Feature freeze, but there may be time for others to make some improvements before 8.1.
> We have also looked at this for at least 2 releases now. If it doesn't get in now, it will just get in for 8.2 and no improvements till 8.2.

Just my own two cents. First I am not knocking the work that has been on
autovacuum. I am sure that it was a leap on its own to get it to work.
However I will say that I just don't see the reason for it.

Vacuum especially in the 8.x series isn't that bad. Heck if you actually
manage your catalog even on large databases it can be reasonable. Yes
it takes a little **gasp** administrative maintenance to run vacuum at
just that right time, on just those right tables but...

Anyway -- it seems it may be beneficial to focus the efforts somewhere
else. The only reason I wanted to know if it was going to be in the
backend last week was because I needed to know if I was going to have
to document in the new book.

Sincerely,

Joshua D. Drake

>
> Regards
>
> Russell Smith
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2005-06-16 04:04:33 Re: Autovacuum in the backend
Previous Message Gavin Sherry 2005-06-16 03:56:41 Re: Autovacuum in the backend

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2005-06-16 04:04:33 Re: Autovacuum in the backend
Previous Message Gavin Sherry 2005-06-16 03:56:41 Re: Autovacuum in the backend