Re: testing HS/SR - 1 vs 2 performance

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: testing HS/SR - 1 vs 2 performance
Дата
Msg-id 4BD0C5AF.6070206@catalyst.net.nz
обсуждение исходный текст
Ответ на Re: testing HS/SR - 1 vs 2 performance  (Greg Smith <greg@2ndquadrant.com>)
Ответы Re: testing HS/SR - 1 vs 2 performance
Список 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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: testing HS/SR - 1 vs 2 performance
Следующее
От: "Erik Rijkers"
Дата:
Сообщение: Re: testing HS/SR - 1 vs 2 performance