Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-07-04 Thread Magnus Hagander
On Mon, Jul 2, 2012 at 8:17 PM, Fujii Masao wrote: > On Mon, Jul 2, 2012 at 4:01 AM, Magnus Hagander wrote: >> On Sun, Jul 1, 2012 at 7:14 PM, Fujii Masao wrote: >>> >>> On Fri, Jun 29, 2012 at 7:22 PM, Magnus Hagander >>> wrote: On Wed, Jun 27, 2012 at 7:24 PM, Fujii Masao wrote: >

Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-07-02 Thread Fujii Masao
On Mon, Jul 2, 2012 at 4:01 AM, Magnus Hagander wrote: > On Sun, Jul 1, 2012 at 7:14 PM, Fujii Masao wrote: >> >> On Fri, Jun 29, 2012 at 7:22 PM, Magnus Hagander wrote: >>> On Wed, Jun 27, 2012 at 7:24 PM, Fujii Masao wrote: On Thu, Jun 21, 2012 at 3:18 AM, Robert Haas wrote: > On We

Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-07-01 Thread Magnus Hagander
On Sun, Jul 1, 2012 at 7:14 PM, Fujii Masao wrote: > > On Fri, Jun 29, 2012 at 7:22 PM, Magnus Hagander wrote: >> On Wed, Jun 27, 2012 at 7:24 PM, Fujii Masao wrote: >>> On Thu, Jun 21, 2012 at 3:18 AM, Robert Haas wrote: On Wed, Jun 20, 2012 at 7:18 AM, Magnus Hagander wrote: >

Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-07-01 Thread Fujii Masao
Thanks for the review! On Fri, Jun 29, 2012 at 7:22 PM, Magnus Hagander wrote: > On Wed, Jun 27, 2012 at 7:24 PM, Fujii Masao wrote: >> On Thu, Jun 21, 2012 at 3:18 AM, Robert Haas wrote: >>> On Wed, Jun 20, 2012 at 7:18 AM, Magnus Hagander >>> wrote: >>> You agreed to add something like

Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-29 Thread Magnus Hagander
On Wed, Jun 27, 2012 at 7:24 PM, Fujii Masao wrote: > On Thu, Jun 21, 2012 at 3:18 AM, Robert Haas wrote: >> On Wed, Jun 20, 2012 at 7:18 AM, Magnus Hagander wrote: >> You agreed to add something like NOSYNC option into START_REPLICATION >> command? > > I'm on the fence. I was h

Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-29 Thread Magnus Hagander
On Wed, Jun 27, 2012 at 7:58 PM, Simon Riggs wrote: > On 27 June 2012 18:24, Fujii Masao wrote: > >> will never become sync standby even >> if their name is in synchronous_standby_names. > > I don't understand why you'd want that. > > What is wrong with removing the name from synchronous_standby_

Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-27 Thread Simon Riggs
On 27 June 2012 18:24, Fujii Masao wrote: > will never become sync standby even > if their name is in synchronous_standby_names. I don't understand why you'd want that. What is wrong with removing the name from synchronous_standby_names if you don't like it? --  Simon Riggs  

Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-27 Thread Fujii Masao
On Thu, Jun 21, 2012 at 3:18 AM, Robert Haas wrote: > On Wed, Jun 20, 2012 at 7:18 AM, Magnus Hagander wrote: > You agreed to add something like NOSYNC option into START_REPLICATION > command? I'm on the fence. I was hoping somebody else would chime in with an opinion as w

Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-20 Thread Robert Haas
On Wed, Jun 20, 2012 at 7:18 AM, Magnus Hagander wrote: You agreed to add something like NOSYNC option into START_REPLICATION command? >>> >>> I'm on the fence. I was hoping somebody else would chime in with an >>> opinion as well. >> >> +1 > > Nobody else with any opinion on this? :(

Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-20 Thread Simon Riggs
On 11 June 2012 23:47, Magnus Hagander wrote >> You agreed to add something like NOSYNC option into START_REPLICATION >> command? > > I'm on the fence. I was hoping somebody else would chime in with an > opinion as well. Why would you add it to synchronous_standby_names and then explicitly igno

Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-20 Thread Magnus Hagander
On Mon, Jun 11, 2012 at 6:06 PM, Fujii Masao wrote: > On Tue, Jun 12, 2012 at 12:47 AM, Magnus Hagander wrote: >> On Mon, Jun 11, 2012 at 5:37 PM, Fujii Masao wrote: >>> On Mon, Jun 11, 2012 at 3:24 AM, Magnus Hagander >>> wrote: On Sun, Jun 10, 2012 at 6:08 PM, Fujii Masao wrote: >

Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-11 Thread Fujii Masao
On Tue, Jun 12, 2012 at 12:47 AM, Magnus Hagander wrote: > On Mon, Jun 11, 2012 at 5:37 PM, Fujii Masao wrote: >> On Mon, Jun 11, 2012 at 3:24 AM, Magnus Hagander wrote: >>> On Sun, Jun 10, 2012 at 6:08 PM, Fujii Masao wrote: On Sun, Jun 10, 2012 at 11:45 PM, Magnus Hagander wrote:

Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-11 Thread Magnus Hagander
On Mon, Jun 11, 2012 at 5:37 PM, Fujii Masao wrote: > On Mon, Jun 11, 2012 at 3:24 AM, Magnus Hagander wrote: >> On Sun, Jun 10, 2012 at 6:08 PM, Fujii Masao wrote: >>> On Sun, Jun 10, 2012 at 11:45 PM, Magnus Hagander >>> wrote: On Sun, Jun 10, 2012 at 4:29 PM, Fujii Masao wrote: >