On Mon, Apr 12, 2010 at 8:32 AM, Jim Mlodgenski <jimmy76(at)gmail(dot)com> wrote:
>> I think we need to investigate this more. It's not going to look good
>> for the project if people find that a hot standby server runs two
>> orders of magnitude slower than the primary.
> As a data point, I did a read only pgbench test and found that the
> standby runs about 15% slower than the primary with identical hardware
> and configs.
Hmm. That's not great, but it's a lot better than 50x. I wonder what
was different in Erik's environment. Does running in standby mode use
more memory, such that it might have pushed the machine over the line
Or if it's CPU load, maybe Erik could gprof it?
In response to
pgsql-hackers by date
|Next:||From: Aidan Van Dyk||Date: 2010-04-12 13:30:01|
|Subject: Re: testing HS/SR - 1 vs 2 performance|
|Previous:||From: Robert Haas||Date: 2010-04-12 13:04:49|
|Subject: Re: Streaming replication and a disk full in primary|