From: Luke Lonergan <llonergan@greenplum.com>
To: arnaulist@andromeiberica.com
To: pgsql-performance@postgresql.org
Subject: Re: Where is my bottleneck?
Date: Mon, 30 Jan 2006 08:49:04 -0800
Message-ID: <C0038380.1B47B%llonergan@greenplum.com> (raw)
In-Reply-To: <43D67496.2020203@androme.es>
Arnau,
On 1/24/06 10:40 AM, "Arnau Rebassa Villalonga" <arebassa@androme.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: llonergan@greenplum.com, arnaulist@andromeiberica.com
Subject: Re: Where is my bottleneck?
In-Reply-To: <C0038380.1B47B%llonergan@greenplum.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox