Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-04-18 Thread Robert Haas
On Tue, Apr 17, 2012 at 3:29 PM, Fujii Masao masao.fu...@gmail.com wrote: Okay, patch attached. Committed. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-04-17 Thread Thom Brown
On 16 April 2012 17:21, Fujii Masao masao.fu...@gmail.com wrote: On Sun, Apr 15, 2012 at 12:13 AM, Thom Brown t...@linux.com wrote: No, that's not what I was referring to.  If you don't have a standby (i.e. a single, isolated database cluster with no replication), and its synchronous_commit is

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-04-17 Thread Fujii Masao
On Tue, Apr 17, 2012 at 9:52 PM, Thom Brown t...@linux.com wrote: On 16 April 2012 17:21, Fujii Masao masao.fu...@gmail.com wrote: On Sun, Apr 15, 2012 at 12:13 AM, Thom Brown t...@linux.com wrote: No, that's not what I was referring to.  If you don't have a standby (i.e. a single, isolated

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-04-16 Thread Fujii Masao
On Sun, Apr 15, 2012 at 12:13 AM, Thom Brown t...@linux.com wrote: On 14 April 2012 15:58, Fujii Masao masao.fu...@gmail.com wrote: On Sat, Apr 14, 2012 at 4:16 AM, Thom Brown t...@linux.com wrote: I have a question though.  What happens when this is set to write (or remote_write as proposed)

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-04-14 Thread Fujii Masao
On Sat, Apr 14, 2012 at 4:57 AM, Guillaume Lelarge guilla...@lelarge.info wrote: On 04/13/2012 08:15 PM, Kevin Grittner wrote: Robert Haasrobertmh...@gmail.com  wrote: In my view, remote_write seems a lot more clear than write +1 I sure didn't understand it to mean remote_write when I

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-04-14 Thread Robert Haas
On Sat, Apr 14, 2012 at 10:28 AM, Fujii Masao masao.fu...@gmail.com wrote: On Sat, Apr 14, 2012 at 4:57 AM, Guillaume Lelarge guilla...@lelarge.info wrote: On 04/13/2012 08:15 PM, Kevin Grittner wrote: Robert Haasrobertmh...@gmail.com  wrote: In my view, remote_write seems a lot more clear

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-04-14 Thread Fujii Masao
On Sat, Apr 14, 2012 at 4:16 AM, Thom Brown t...@linux.com wrote: On 13 April 2012 19:15, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Robert Haas robertmh...@gmail.com wrote: In my view, remote_write seems a lot more clear than write +1 I sure didn't understand it to mean

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-04-14 Thread Thom Brown
On 14 April 2012 15:58, Fujii Masao masao.fu...@gmail.com wrote: On Sat, Apr 14, 2012 at 4:16 AM, Thom Brown t...@linux.com wrote: I have a question though.  What happens when this is set to write (or remote_write as proposed) but it's being used on a standalone primary?  At the moment it's

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-04-13 Thread Robert Haas
On Thu, Jan 26, 2012 at 1:21 AM, Fujii Masao masao.fu...@gmail.com wrote: On Wed, Jan 25, 2012 at 11:12 PM, Simon Riggs si...@2ndquadrant.com wrote: On Wed, Jan 25, 2012 at 1:57 PM, Robert Haas robertmh...@gmail.com wrote: I think that this would be a lot more clear if we described this as

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-04-13 Thread Kevin Grittner
Robert Haas robertmh...@gmail.com wrote: In my view, remote_write seems a lot more clear than write +1 I sure didn't understand it to mean remote_write when I read the subject line. -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-04-13 Thread Thom Brown
On 13 April 2012 19:15, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Robert Haas robertmh...@gmail.com wrote: In my view, remote_write seems a lot more clear than write +1 I sure didn't understand it to mean remote_write when I read the subject line. Whatever this option value is

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-04-13 Thread Guillaume Lelarge
On 04/13/2012 08:15 PM, Kevin Grittner wrote: Robert Haasrobertmh...@gmail.com wrote: In my view, remote_write seems a lot more clear than write +1 I sure didn't understand it to mean remote_write when I read the subject line. Neither did I. So definitely +1. -- Guillaume

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-01-25 Thread Robert Haas
On Wed, Jan 25, 2012 at 1:23 AM, Fujii Masao masao.fu...@gmail.com wrote: On Wed, Jan 25, 2012 at 5:35 AM, Jaime Casanova ja...@2ndquadrant.com wrote: On Tue, Jan 24, 2012 at 3:22 PM, Simon Riggs si...@2ndquadrant.com wrote: Add new replication mode synchronous_commit = 'write'. Replication

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-01-25 Thread Simon Riggs
On Wed, Jan 25, 2012 at 1:57 PM, Robert Haas robertmh...@gmail.com wrote: I think that this would be a lot more clear if we described this as synchronous_commit = remote_write rather than just synchronous_commit = write.  Actually, the internal constant is named that way already, but it's not

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-01-25 Thread Fujii Masao
On Wed, Jan 25, 2012 at 11:12 PM, Simon Riggs si...@2ndquadrant.com wrote: On Wed, Jan 25, 2012 at 1:57 PM, Robert Haas robertmh...@gmail.com wrote: I think that this would be a lot more clear if we described this as synchronous_commit = remote_write rather than just synchronous_commit =

Re: [HACKERS] [COMMITTERS] pgsql: Add new replication mode synchronous_commit = 'write'.

2012-01-24 Thread Fujii Masao
On Wed, Jan 25, 2012 at 5:35 AM, Jaime Casanova ja...@2ndquadrant.com wrote: On Tue, Jan 24, 2012 at 3:22 PM, Simon Riggs si...@2ndquadrant.com wrote: Add new replication mode synchronous_commit = 'write'. Replication occurs only to memory on standby, not to disk, so provides additional