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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)