X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 41A959DC848 for ; Mon, 30 Jan 2006 12:58:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22333-02 for ; Mon, 30 Jan 2006 12:58:06 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.Mi8.com (d01gw01.mi8.com [63.240.6.47]) by postgresql.org (Postfix) with ESMTP id D4E569DC86F for ; Mon, 30 Jan 2006 12:58:05 -0400 (AST) Received: from 172.16.1.110 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Mon, 30 Jan 2006 11:57:56 -0500 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01SMTP01.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 30 Jan 2006 11:57:55 -0500 Received: from 67.103.45.218 ([67.103.45.218]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.105]) with Microsoft Exchange Server HTTP-DAV ; Mon, 30 Jan 2006 16:57:53 +0000 User-Agent: Microsoft-Entourage/11.2.1.051004 Date: Mon, 30 Jan 2006 08:49:04 -0800 Subject: Re: Where is my bottleneck? From: "Luke Lonergan" To: arnaulist@andromeiberica.com, pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Where is my bottleneck? Thread-Index: AcYlTXJlmh467zVYQt+IukMO5Z5s6wAb6GIY In-Reply-To: <43D67496.2020203@androme.es> MIME-Version: 1.0 X-OriginalArrivalTime: 30 Jan 2006 16:57:55.0439 (UTC) FILETIME=[50B067F0:01C625BE] X-WSS-ID: 6FC09A1B32K768491-02-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.292 required=5 tests=[AWL=0.039, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.292 X-Spam-Level: * X-Archive-Number: 200601/476 X-Sequence-Number: 16954 Arnau, On 1/24/06 10:40 AM, "Arnau Rebassa Villalonga" 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