Re: testing HS/SR - 1 vs 2 performance - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Re: testing HS/SR - 1 vs 2 performance
Date
Msg-id 4BD0C5AF.6070206@catalyst.net.nz
Whole thread Raw
In response to Re: testing HS/SR - 1 vs 2 performance  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: testing HS/SR - 1 vs 2 performance  ("Erik Rijkers" <er@xs4all.nl>)
List pgsql-hackers
Greg Smith wrote:
> Erik Rijkers wrote:
>> This is the same behaviour (i.e. extreme slow standby) that I saw 
>> earlier (and which caused the
>> original post, btw).  In that earlier instance, the extreme slowness 
>> disappeared later, after many
>> hours maybe even days (without bouncing either primary or standby).
>>   
>
> Any possibility the standby is built with assertions turned out?  
> That's often the cause of this type of difference between pgbench 
> results on two systems, which easy to introduce when everyone is 
> building from source.  You should try this on both systems:
>
> psql -c "show debug_assertions"
>
>
>
Or even:

pg_config --configure

on both systems might be worth checking.


regards

Mark



pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: testing HS/SR - 1 vs 2 performance
Next
From: "Erik Rijkers"
Date:
Subject: Re: testing HS/SR - 1 vs 2 performance