Re: turning fsync off for WAL - Mailing list pgsql-general

From Ram Ravichandran
Subject Re: turning fsync off for WAL
Date
Msg-id c8cd6fbb0806030448w2f93f2bcr836431da4c6b9f52@mail.gmail.com
Whole thread Raw
In response to Re: turning fsync off for WAL  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-general

Ahh. I think you can use this effectively but not the way you're describing.

Instead of writing the wal directly to persistentFS what I think you're better
off doing is treating persistentFS as your backup storage. Use "Archiving" as
described here to archive the WAL files to persistentFS:

http://postgresql.com.cn/docs/8.3/static/runtime-config-wal.html#GUC-ARCHIVE-MODE

Looks like this is the best solution.

Thanks,

Ram

pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: turning fsync off for WAL
Next
From: "Ivan Zolotukhin"
Date:
Subject: Re: Cannot drop user (PostgreSQL 8.1.11)