Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id C5CEF2E002D
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 24 Mar 2008 10:17:56 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 25825-05 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 24 Mar 2008 10:17:53 -0300 (ADT)
X-Greylist: delayed 01:57:23.397719 by SQLgrey-1.7.5
Received: from h07.llord.com (unknown [195.140.142.194])
	by postgresql.org (Postfix) with ESMTP id A79182E003F
	for <pgsql-performance@postgresql.org>;
	Mon, 24 Mar 2008 10:17:53 -0300 (ADT)
Received: from par69-8-88-161-102-87.fbx.proxad.net ([88.161.102.87]
	helo=apollo13.peufeu.com) by h07.llord.com with esmtpa (Exim 4.68)
	(envelope-from <lists@peufeu.com>)
	id 1JdmYg-0000IE-IA; Mon, 24 Mar 2008 14:17:50 +0100
To: "petchimuthu lingam" <spmlingam@gmail.com>,
	pgsql-performance@postgresql.org
Subject: Re: waiting for harddisk
From: PFC <lists@peufeu.com>
Content-Type: text/plain; format=flowed; delsp=yes; charset=utf-8
MIME-Version: 1.0
References: <cd233fc30803240605k2a7ae66w90487449ae07d051@mail.gmail.com>
Content-Transfer-Encoding: Quoted-Printable
Date: Mon, 24 Mar 2008 14:20:56 +0100
Message-ID: <op.t8ivc6adcigqcu@apollo13.peufeu.com>
In-Reply-To: <cd233fc30803240605k2a7ae66w90487449ae07d051@mail.gmail.com>
User-Agent: Opera Mail/9.24 (Linux)
X-AntiAbuse: This header was added to track abuse,
	please include it with any abuse report
X-AntiAbuse: Primary Hostname - h07.llord.com
X-AntiAbuse: Original Domain - postgresql.org
X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse: Sender Address Domain - peufeu.com
X-Source: 
X-Source-Args: 
X-Source-Dir: 
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.149 tagged_above=0 required=5 tests=AWL=1.049,
	RDNS_NONE=0.1
X-Spam-Level: *
X-Archive-Number: 200803/445
X-Sequence-Number: 29399

> i am using postgresql 8.1.8,
>
> Following configurations:
>            shared_buffers =3D 5000
>             work_mem =3D 65536
>             maintenance_work_mem =3D 65536
>             effective_cache_size =3D 16000
>             random_page_cost =3D 0.1
>
> The cpu is waiting percentage goes upto 50%, and query result comes  =

> later,
>
> i am using normal select query ( select * from table_name ).
>
> table has more then 6 million records.



	When you mean SELECT *, are you selecting the WHOLE 6 million records ?=
  =

Without WHERE ? Or just a few rows ?
	Please post EXPLAIN ANALYZE of your query.