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