| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Greg Stark <gsstark(at)mit(dot)edu> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: wal_buffer tests in |
| Date: | 2005-07-28 21:57:10 |
| Message-ID: | 200507281457.10637.josh@agliodbs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Greg,
> You have wal_buffer set to 2048? That's pretty radical compared to the
> default of just 5. Your tests shows you had to go to this large a value
> to see the maximum effect?
No, take a look at the graph. It looks like we got the maximum effect
from a wal_buffers somewhere between 64 and 256. On the DBT2 runs, any
variation less than 5% is just noise.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-07-28 22:14:03 | Re: psql tab-completion for COMMIT/ROLLBACK PREPARED |
| Previous Message | Tom Lane | 2005-07-28 20:41:27 | Re: Interesting COPY edge case... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karim Nassar | 2005-07-28 23:04:25 | Two queries are better than one? |
| Previous Message | Luke Lonergan | 2005-07-28 18:27:36 | Re: Finding bottleneck |