Matthew T. O'Connor wrote:
> > > this happens with other big tables too. the autovacuum is from 7.4.2,
> > > some information is below.
> >
> > Oh, 7.4.2. I know we have some known bug and are waiting on a patch for
> > it.
> >
> > Matthew, we need those fixes for pg_autovacuum soon.
>
> As I said above this problem is already fixed, unfortunately it was
> fixed just after the 7.4.2 release so it's been sitting in CVS for a
> while.
>
> The only outstanding bug I need to fix that I'm aware of is the temp
> table issue. Everything else I'm planning on is development work for
> 7.5, mostly integrating it into the backend directly.
>
> If anyone is aware of some other bug that I'm not thinking about please
> let me know.
OK, thanks. Sorry, I got confused. I thought there was more. Oh, yea,
there is the issue of sending a query and not checking if the return is
null.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073