Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: turning fsy...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 15711 of 17437
Post > Topic >>

Re: turning fsync off for WAL

by simon@[EMAIL PROTECTED] (Simon Riggs) Jun 3, 2008 at 08:26 AM

On Tue, 2008-06-03 at 00:04 -0400, Ram Ravichandran wrote:

> This seems like a much better idea. So, I should 
> a) disable synchronous_commit 
> b) set wal_writer_delay to say 1 minute (and leave fsync on)
> c) symlink pg_xlog to the PersistentFS on S3.
> 

a) sounds good. b) has a max setting of 10 seconds, which I think is a
realistic maximum in this case also.

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Sup****t


-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 1 Posts in Topic:
Re: turning fsync off for WAL
simon@[EMAIL PROTECTED]   2008-06-03 08:26:52 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 12:22:59 CST 2008.