New sync commit mode remote_write

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: New sync commit mode remote_write
Date: 2012-04-19 09:05:02
Message-ID: CABUevEzARzVAiPFK7pGO205fWVFhP5uV+UUhwiBmQ-mCGuuJDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I admit to not having followed the discussion around the new mode for
synchronous_commit very closely, so my apologies if this has been
discussed and dismiseed - I blame failing to find it int he archives
;)

My understanding from looking at the docs is that
synchronous_commit=remote_write will always imply a *local* commit as
well.

Is there any way to set the system up to do a write to the remote,
ensure it's in memory of the remote (remote_write mode, not full sync
to disk), but *not* necessarily to the local disk? Meaning we're ok to
release the transaction when the data is in memory both locally and
remotely but not wait for I/O?

Seems there is a pretty large usecase for this particular in our
lovely new cloud environments with pathetic I/O performance....

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sandro Santilli 2012-04-19 09:21:11 Re: Gsoc2012 idea, tablesample
Previous Message Jeff Davis 2012-04-19 08:10:58 Re: 9.3 Pre-proposal: Range Merge Join