Re: PostgreSQL Reliability when fsync = false on Linux-XFS - Mailing list pgsql-performance

From Tom Lane
Subject Re: PostgreSQL Reliability when fsync = false on Linux-XFS
Date
Msg-id 21373.1062683328@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL Reliability when fsync = false on Linux-XFS  (Sean Chittenden <sean@chittenden.org>)
List pgsql-performance
Sean Chittenden <sean@chittenden.org> writes:
>> Just wonderin. What if you symlink WAL to a directory which is on
>> mounted USB RAM drive?

> USB 2.0 you mean?  It supposedly runs at 1394 speeds, but USB 1.0/1.1
> runs at 1MB/s under ideal circumstances... that's slower than even old
> IDE drives.

>> Will that increase any throughput?

> Probably not...

Also, doesn't flash memory have a very limited lifetime in write cycles?
Using it as WAL, you'd wear it out PDQ.

            regards, tom lane

pgsql-performance by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: SELECT's take a long time compared to other DBMS
Next
From: "Relaxin"
Date:
Subject: Re: SELECT's take a long time compared to other DBMS