Re: [Testperf-general] pg_autovacuum w/ dbt2

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