| From: | Ramsey Gurley <rgurley(at)smarthealth(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Tuning read ahead continued... |
| Date: | 2013-05-17 00:56:01 |
| Message-ID: | 4551B664-515D-48DE-92CE-3BDC3C8C5E8B@smarthealth.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi All,
I tried bumping my read ahead up to 4096. Instead of having faster reads, it seems it actually slowed things down. In fact, most of the tuning suggestions I've tried have made little to no difference in the results I get from bonnie++. I'll include a table of values in html. I'm wondering if these are normal values in my case; 4 disk RAID10 Linux ext3 146GB SAS 15K RPM Drive.
| Attachment | Content-Type | Size |
|---|---|---|
| benchmarks.html | text/html | 3.1 KB |
| unknown_filename | text/plain | 20 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | chiru r | 2013-05-17 04:01:15 | Re: About replacing PostgreSQL instance |
| Previous Message | David Kerr | 2013-05-16 23:35:22 | Re: LONG delete with LOTS of FK's |