| From: | Aidan Van Dyk <aidan(at)highrise(dot)ca> |
|---|---|
| To: | Tomas Vondra <tv(at)fuzzy(dot)cz> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Tablespaces on a raid configuration |
| Date: | 2012-03-31 13:42:49 |
| Message-ID: | CAC_2qU-DrOZSV3gVfZnqdVQ3TWo-pbD3SuCYKessNHaWs0LVKg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Fri, Mar 30, 2012 at 9:32 PM, Tomas Vondra <tv(at)fuzzy(dot)cz> wrote:
> And it's not just about fsync operations - WAL is written in sequential
> manner. By placing it on the same device as data files you're
> effectively forcing it to be written randomly, because the the database
> has to write a WAL record, seeks somewhere else to read something, etc.
Or, if you put WAL on a journalled FS, even if it's on dedicated spindles ;-)
a.
--
Aidan Van Dyk Create like a god,
aidan(at)highrise(dot)ca command like a king,
http://www.highrise.ca/ work like a slave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Lunney | 2012-04-01 02:20:03 | Re: database slowdown while a lot of inserts occur |
| Previous Message | Tomas Vondra | 2012-03-31 01:32:31 | Re: Tablespaces on a raid configuration |