Re: Update on putting WAL on ramdisk/

From: "Russell Garrett" <rg(at)tcslon(dot)com>
To: "William Yu" <wyu(at)talisys(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Update on putting WAL on ramdisk/
Date: 2003-12-12 22:36:26
Message-ID: MKEGJINFADFODDNOKEJCIEEFEMAA.rg@tcslon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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(at)last(dot)fm
http://last.fm

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Chadwick, Russell 2003-12-12 22:40:28 Excessive rows/tuples seriously degrading query performance
Previous Message William Yu 2003-12-12 22:02:03 Update on putting WAL on ramdisk/