| From: | Mark Wong <markw(at)osdl(dot)org> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | testperf-general(at)pgfoundry(dot)org |
| Subject: | pg_autovacuum w/ dbt2 |
| Date: | 2004-12-21 17:41:31 |
| Message-ID: | 20041221094131.B20272@osdl.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-www |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-12-21 17:50:56 | Re: port report: [FAILURE] FreeBSD 6, Intel icc7 |
| Previous Message | Darcy Buskermolen | 2004-12-21 17:26:50 | Re: port report: [FAILURE] FreeBSD 6, Intel icc7 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2004-12-21 19:12:57 | Re: Launch now??? |
| Previous Message | Oleg Bartunov | 2004-12-21 17:29:13 | Re: Ready to launch? |