Skip site navigation (1) Skip section navigation (2)

Re: H800 + md1200 Performance problem

From: Tomas Vondra <tv(at)fuzzy(dot)cz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: H800 + md1200 Performance problem
Date: 2012-04-03 13:21:42
Message-ID: 4F7AF966.20809@fuzzy.cz (view raw or flat)
Thread:
Lists: pgsql-performance
On 3.4.2012 14:59, Cesar Martin wrote:
> Hi Mike,
> Thank you for your fast response.
> 
> blockdev --getra /dev/sdc
> 256

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.

Tomas

In response to

Responses

pgsql-performance by date

Next:From: Robert HaasDate: 2012-04-03 14:21:10
Subject: Re: Performance of SQL Function versus View
Previous:From: Merlin MoncureDate: 2012-04-03 13:11:32
Subject: Re: H800 + md1200 Performance problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group