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

From Erik Rijkers
Subject Re: testing HS/SR - 1 vs 2 performance
Date
Msg-id 59f35a8ab4d22cb011d2fe8acdee7637.squirrel@webmail.xs4all.nl
Whole thread Raw
In response to Re: testing HS/SR - 1 vs 2 performance  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Mon, April 26, 2010 09:43, Simon Riggs wrote:
> On Sun, 2010-04-25 at 23:52 +0200, Erik Rijkers wrote:
>
>> I'll try to repeat this pattern on other hardware; although
>> if my tests were run with faulty hardware I wouldn't know how/why
>> that would give the above effect (such a 'regular aberration').
>
>> testing is more difficult than I thought...
>
> Thanks again for your help.
>
> Please can you confirm:
> * Are the standby tests run while the primary is completely quiet?

autovacuum was on. Which is probably not a good idea - I'll try a few runs without it.

> * What OS is this? Can we use dtrace scripts?

Centos 5.4.




pgsql-hackers by date:

Previous
From: "Erik Rijkers"
Date:
Subject: Re: testing HS/SR - 1 vs 2 performance
Next
From: "Murali M. Krishna"
Date:
Subject: Discarding the resulting rows