| From: | Ramsey Gurley <rgurley(at)smarthealth(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Tuning read ahead |
| Date: | 2013-05-16 01:04:14 |
| Message-ID: | 9614AFD8-9713-43CC-8E32-4A530C9FD3F5@smarthealth.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all,
I've just gotten into my new database server yesterday and I've started doing database setup and tuning.
I'm on a Rackspace Linux server with two raid arrays. Both are ext3. One is a two disk RAID1 I plan on using for WAL and OS, the other is a four disk RAID10 I will use for the data.
I read in Postgres 9.0 High Performance that one of the most important parameters I should tune is the device read-ahead.
My question: Is that advice just for the database drive, or should I increase read ahead on the OS/WAL disk as well? I assume both. I should ask the same for noatime advice while I'm at it. Is it important to disable atime on the WAL as well as the data?
Thanks,
Ramsey
| From | Date | Subject | |
|---|---|---|---|
| Next Message | itishree sukla | 2013-05-16 04:21:20 | Creating Extension pg_trgm |
| Previous Message | Carlos Henrique Reimer | 2013-05-15 21:35:58 | Re: |