Postgres Pro
Downloads
Home   >   mailing lists

Re: Update on putting WAL on ramdisk/ - Mailing list pgsql-performance

From Russell Garrett
Subject Re: Update on putting WAL on ramdisk/
Date
Msg-id MKEGJINFADFODDNOKEJCIEEFEMAA.rg@tcslon.com
Whole thread Raw
In response to Update on putting WAL on ramdisk/  (William Yu <wyu@talisys.com>)
Responses Re: Update on putting WAL on ramdisk/
List pgsql-performance
Tree view 
> WAL on single drive: 7.990 rec/s
> WAL on 2nd IDE drive: 8.329 rec/s
> WAL on tmpfs: 13.172 rec/s
>
> A huge jump in performance but a bit scary having a WAL that can
> disappear at any time. I'm gonna workup a rsync script and do some
> power-off experiments to see how badly it gets mangled.

Surely this is just equivalent to disabling fsync? If you put a WAL on a
volatile file system, there's not a whole lot of point in having one at all.

--------------------------------------------------------------------
Russ Garrett                                            russ@last.fm
                                                      http://last.fm

pgsql-performance by date:

Previous
From: William Yu
Date:
Subject: Update on putting WAL on ramdisk/
Next
From: William Yu
Date:
Subject: Re: Update on putting WAL on ramdisk/