Re: Where is my bottleneck?

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: arnaulist(at)andromeiberica(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: Where is my bottleneck?
Date: 2006-01-30 16:49:04
Message-ID: C0038380.1B47B%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Arnau,

On 1/24/06 10:40 AM, "Arnau Rebassa Villalonga" <arebassa(at)androme(dot)es> wrote:

> I know it's a problem with a very big scope, but could you give me a
> hint about where I should look to?

Try this:

time bash -c "dd if=/dev/zero of=bigfile bs=8k count=2000000 && sync"
time dd if=bigfile of=/dev/null bs=8k

And report the results back here. If it takes too long to complete (more
than a couple of minutes), bring up another window and run "vmstat 1" then
report the values in the columns "bi" and "bo".

- Luke

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message hubert depesz lubaczewski 2006-01-30 17:53:29 Re: Huge Data sets, simple queries
Previous Message Michael Stone 2006-01-30 11:00:49 Re: Where is my bottleneck?