Re: [HACKERS] Autovacuum loose ends

On Fri, Aug 12, 2005 at 03:16:04PM -0700, Mark Wong wrote:
> On Fri, 12 Aug 2005 17:49:41 -0400
> Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
>
> > Notice how the subindexes are wrong ... I think it should be 1:3 for
> > i_orders, no?  Apparently indexes_scan.data has the same problem.
>
> Whoops!  I think I fixed it for real now and the charts should be
> updated now.  It was broken slightly more previously.

Hmm, did you fix the 42 case only?  The other one is broken too ...

Also, it seems the "tran_lock.out" file captured wrong input -- I think
you mean "WHERE transactionid IS NULL" in the query instead of "WHERE
transaction IS NULL".

I wonder what the big down-spikes (?) at minutes ~45 and ~85 correspond
to.  Are those checkpoints?  The IO vmstat chart would indicate that, I
think.


Anyway, it's interesting to see the performance go up with autovacuum
on.  I certainly didn't expect that in this kind of test.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"No necesitamos banderas
 No reconocemos fronteras"                  (Jorge González)