On 3.4.2012 14:59, Cesar Martin wrote:
> Hi Mike,
> Thank you for your fast response.
> blockdev --getra /dev/sdc
That's way too low. Is this setting the same on both machines?
Anyway, set it to 4096, 8192 or even 16384 and check the difference.
BTW explain analyze is nice, but it's only half the info, especially
when the issue is outside PostgreSQL (hw, OS, ...). Please, provide
samples from iostat / vmstat or tools like that.
In response to
pgsql-performance by date
|Next:||From: Robert Haas||Date: 2012-04-03 14:21:10|
|Subject: Re: Performance of SQL Function versus View|
|Previous:||From: Merlin Moncure||Date: 2012-04-03 13:11:32|
|Subject: Re: H800 + md1200 Performance problem|