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)
