Re: [Testperf-general] pg_autovacuum w/ dbt2 - Mailing list pgsql-hackers

Yeah, same hardware and database configuration.

No manual vacuum commands before.  The decline in performance has been
pretty consistent in all my previous tests and people have told me on
many occasions that the decline in performance was probably because I
was never using vacuum...

Mark

On Fri, Jan 07, 2005 at 08:48:52AM -0500, Matthew T. O'Connor wrote:
> I'm curious, the original run you posted with 3825 NOTPM is still 17% 
> faster than the latest pg_autovacuum run which shows 3280 NOTPM.  Is 
> this on the same hardware?  Also, did the original non-pg_autovacuum run 
> any manual vacuum commands?  Also, does the non-pg_autovacuum run start 
> slowing down after a while? The graphs look like there is a slight 
> decline in performance as time goes on, what happens if you double the 
> length of the test?
> 
> Thanks for doing the testing!
> 
> Matthew
> 
> 
> Mark Wong wrote:
> 
> >I apologize for the significant delay, here's a link to results to a
> >test with 8.0rc3:
> >    http://www.osdl.org/projects/dbt2dev/results/dev4-010/236/
> >
> >These are the same parameters with as run 215, listed below with the
> >but with --enable-debug --enable-cassert.  I also ran pg_autovacuum
> >with -d4, where the output can be seen here:
> >    http://www.osdl.org/projects/dbt2dev/results/dev4-010/236/dbt2.out
> >
> >I, uh, wasn't able to reproduce the previous errors after repairing my
> >filesystems after a power outage.  So I figure that might be good news.
> >The performance is up from run 215 with the errors, so I'll continue
> >with trying to tune some of the pg_autovacuum values.
> >
> >Mark
> >
> >
> >On Tue, Dec 21, 2004 at 09:41:31AM -0800, Mark Wong wrote:
> >  
> >
> >>After all this time I finally got around to vacuuming the database
> >>with dbt2 with pg_autovacuum. :)
> >>    http://www.osdl.org/projects/dbt2dev/results/dev4-010/215/
> >>
> >>Doesn't look so good though, probably because I'm not using optimal
> >>settings with pg_autovacuum.  So far I have only tried the default
> >>settings (running without any arguments, except -D).
> >>
> >>The only thing that's peculiar is a number of unexpected rollbacks
> >>across all of the transactions.  I suspect it was something to do with
> >>these messages coming from pg_autovacuum:
> >>
> >>[2004-12-20 15:48:18 PST] ERROR:   Can not refresh statistics information from the database dbt2.
> >>[2004-12-20 15:48:18 PST]          The error is [ERROR:  failed to re-find parent key in "pk_district"
> >>]
> >>
> >>This is with 8.0rc1.  I can get rc2 installed since it just came out.
> >>So let me know what I can try and what not.
> >>
> >>Mark
> >>    
> >>
> >
> >  
> >

-- 
Mark Wong - - markw@osdl.org
Open Source Development Lab Inc - A non-profit corporation
12725 SW Millikan Way - Suite 400 - Beaverton, OR 97005
(503) 906-1932 (office)
(503) 626-2436 (fax)
http://developer.osdl.org/markw/