From: | Mark Wong <markw(at)osdl(dot)org> |
---|---|
To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Autovacuum loose ends |
Date: | 2005-08-12 22:16:04 |
Message-ID: | 200508122215.j7CMFYjA014884@smtp.osdl.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Fri, 12 Aug 2005 17:49:41 -0400
Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
> On Fri, Aug 12, 2005 at 10:49:43AM -0700, Mark Wong wrote:
> > I thought I'd run a couple of tests to see if it would be helpful
> > against CVS from Aug 3, 2005.
> >
> > Here's a run with autovacuum turned off:
> > http://www.testing.osdl.org/projects/dbt2dev/results/dev4-015/42/
> > 5186.55 notpm
> >
> > Autvacuum on with default settings:
> > http://www.testing.osdl.org/projects/dbt2dev/results/dev4-015/38/
> > 5462.23 notpm
>
> Just noticed what seems to be a bug: in
>
> http://www.testing.osdl.org/projects/dbt2dev/results/dev4-015/42/db/index_info.input
>
> plot "index_info.data" using 1:2 title "i_customer" with lines, \
> "index_info.data" using 1:2 title "i_orders" with lines, \
> "index_info.data" using 1:3 title "pk_customer" with lines, \
> "index_info.data" using 1:4 title "pk_district" with lines, \
> "index_info.data" using 1:5 title "pk_item" with lines, \
> "index_info.data" using 1:6 title "pk_new_order" with lines, \
> "index_info.data" using 1:7 title "pk_order_line" with lines, \
> "index_info.data" using 1:8 title "pk_orders" with lines, \
> "index_info.data" using 1:9 title "pk_stock" with lines, \
> "index_info.data" using 1:11 title "pk_warehouse" with lines
>
> 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.
> It called my attention that the pk_warehouse index seems to have a very
> different usage in both runs in index_info, but in indexes_scan they
> seem similar.
Thanks,
Mark
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-08-12 22:42:09 | Re: [HACKERS] Autovacuum loose ends |
Previous Message | Tom Lane | 2005-08-12 21:50:47 | Re: [PATCH] Determining return type of polymorphic function |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-08-12 22:21:56 | Re: [HACKERS] For review: Server instrumentation patch |
Previous Message | Andreas Pflug | 2005-08-12 22:06:16 | Re: [HACKERS] For review: Server instrumentation patch |