On Monday 16 February 2009 11:20:11 Alvaro Herrera wrote:
Joshua D. Drake wrote:
Thanks for the work around, but that is ridiculous. I still say this is
a bug.
Yes, which is why we fixed it on 8.4 by dropping pg_autovacuum. (As
Jaime and Tom say, it's actually pilot error, but the UI is
Robert Treat escreveu:
I think this build is a couple weeks old, but is the pg_autovacuum table
really gone in 8.4, or just deprecated?
It is gone. As stated in the docs [1], pg_autovacuum catalog was just a
workaround.
[1]
Euler Taveira de Oliveira eu...@timbira.com writes:
Robert Treat escreveu:
I think this build is a couple weeks old, but is the pg_autovacuum table
really gone in 8.4, or just deprecated?
It is gone.
http://archives.postgresql.org/pgsql-committers/2009-02/msg00077.php
Joshua D. Drake wrote:
Thanks for the work around, but that is ridiculous. I still say this is
a bug.
Yes, which is why we fixed it on 8.4 by dropping pg_autovacuum. (As
Jaime and Tom say, it's actually pilot error, but the UI is crap so we
fixed it.)
--
Alvaro Herrera
Hello,
I found this today. Note, auto vacuum has been disabled for this
relation for a very, very long time. At the very end you will see that
this relation has been autovacuumed previously as well. We have a manual
cron to vacuum this table every hour so I am unsure why autovacuum is
doing what
On Fri, Feb 13, 2009 at 3:21 PM, Joshua D. Drake j...@commandprompt.com wrote:
Hello,
I found this today. Note, auto vacuum has been disabled for this
relation for a very, very long time. At the very end you will see that
this relation has been autovacuumed previously as well. We have a
On Fri, 2009-02-13 at 15:51 -0500, Jaime Casanova wrote:
On Fri, Feb 13, 2009 at 3:21 PM, Joshua D. Drake j...@commandprompt.com
wrote:
Hello,
I found this today. Note, auto vacuum has been disabled for this
relation for a very, very long time. At the very end you will see that
this
Joshua D. Drake j...@commandprompt.com writes:
Thanks for the work around, but that is ridiculous. I still say this is
a bug. If I say enabled = f, the *only* thing that should be firing
autovacuum on that relation is xid wrap.
Right, and you have the xid wrap timeout set to zero.