Re: [HACKERS] autovacuum not honoring pg_autovacuum in 8.3.5?

2009-02-19 Thread Robert Treat
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

Re: [HACKERS] autovacuum not honoring pg_autovacuum in 8.3.5?

2009-02-19 Thread Euler Taveira de Oliveira
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]

Re: [HACKERS] autovacuum not honoring pg_autovacuum in 8.3.5?

2009-02-19 Thread Tom Lane
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

Re: [HACKERS] autovacuum not honoring pg_autovacuum in 8.3.5?

2009-02-16 Thread Alvaro Herrera
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

[HACKERS] autovacuum not honoring pg_autovacuum in 8.3.5?

2009-02-13 Thread Joshua D. Drake
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

Re: [HACKERS] autovacuum not honoring pg_autovacuum in 8.3.5?

2009-02-13 Thread Jaime Casanova
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

Re: [HACKERS] autovacuum not honoring pg_autovacuum in 8.3.5?

2009-02-13 Thread Joshua D. Drake
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

Re: [HACKERS] autovacuum not honoring pg_autovacuum in 8.3.5?

2009-02-13 Thread Tom Lane
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.