Re: turning fsync off for WAL

From: "Ram Ravichandran" <ramkaka(at)gmail(dot)com>
To: "Gregory Stark" <stark(at)enterprisedb(dot)com>
Cc: "Greg Smith" <gsmith(at)gregsmith(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: turning fsync off for WAL
Date: 2008-06-03 11:48:12
Message-ID: c8cd6fbb0806030448w2f93f2bcr836431da4c6b9f52@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Henrik 2008-06-03 11:55:24 Database growing. Need autovacuum help.
Previous Message Gregory Stark 2008-06-03 11:20:44 Re: turning fsync off for WAL