| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Mark Wong <markw(at)osdl(dot)org> |
| Cc: | testperf-general(at)pgfoundry(dot)org, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [Testperf-general] pg_autovacuum w/ dbt2 |
| Date: | 2005-01-07 18:13:52 |
| Message-ID: | 200501071013.52819.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-www |
Mark,
> All default parameters. Matthew also recommended using the
> vacuum_delay setting so I was about to try that.
Interesting ... the default parameters are quite conservative, running only
when the table has doubled in new rows. So if those spikes are vacuums,
then the DBT2 test is updating or adding 100% of the rows in the orders table
every 6-8 minutes? Does that seem right?
--
Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2005-01-07 18:13:54 | Re: [pgsql-ru-general] Final call for translation updates |
| Previous Message | Marek Mosiewicz | 2005-01-07 18:08:01 | Re: Compiere ERP and SQL quirks |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Wong | 2005-01-07 18:29:23 | Re: [Testperf-general] pg_autovacuum w/ dbt2 |
| Previous Message | Mark Wong | 2005-01-07 18:01:18 | Re: [Testperf-general] pg_autovacuum w/ dbt2 |