Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 502AB2E003C
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 24 Mar 2008 10:06:00 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 66972-09 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 24 Mar 2008 10:05:44 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from wa-out-1112.google.com (wa-out-1112.google.com
 [209.85.146.182])
	by postgresql.org (Postfix) with ESMTP id 6DA6A2E002D
	for <pgsql-performance@postgresql.org>;
	Mon, 24 Mar 2008 10:05:52 -0300 (ADT)
Received: by wa-out-1112.google.com with SMTP id m38so3470520waf.5
	for <pgsql-performance@postgresql.org>;
	Mon, 24 Mar 2008 06:05:51 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	bh=6I+TU/h+2wLnxDOCGu9gJjeUkasfNpHxMMdT+vSaVqk=;
	b=R3JChE22nBAqZipzs8chHD/nA8nKHIMEby8rtGF2990ZAJu+ZfJxeQM3+igqAWjcVw4Ffq3kJMY4cktlEh3Fcf3k5U3qmug4mNI/WSLjCkio6CR3RNzXdRQKw9P+5MpNlOjRBAmBhoUjfG0vEFwrUAHTt/RoMKGz8kKA0lf8fZ8=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=SobchSuCMfooX87OaT3dZ7bMxwspdxIicWUPwKfkHx6yu+TK0dcqgkIgdKH05nwL4NgegFdnGqc0mqPW9R1USzPF8F/ojPG996IDkNLmnkVoHeFDhZ6VWYD3l/xSkcO8VY0UW9O96U2Wo8TqvWDq9oJntjHlGbjbgPW1WlX7EHI=
Received: by 10.115.22.1 with SMTP id z1mr11620563wai.33.1206363951068;
	Mon, 24 Mar 2008 06:05:51 -0700 (PDT)
Received: by 10.114.234.6 with HTTP; Mon, 24 Mar 2008 06:05:51 -0700 (PDT)
Message-ID: <cd233fc30803240605k2a7ae66w90487449ae07d051@mail.gmail.com>
Date: Mon, 24 Mar 2008 18:35:51 +0530
From: "petchimuthu lingam" <spmlingam@gmail.com>
To: pgsql-performance@postgresql.org
Subject: waiting for harddisk
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_9432_1401870.1206363951061"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.14 tagged_above=0 required=5 tests=AWL=0.139,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200803/444
X-Sequence-Number: 29398

------=_Part_9432_1401870.1206363951061
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

i am using postgresql 8.1.8,

Following configurations:
           shared_buffers = 5000
            work_mem = 65536
            maintenance_work_mem = 65536
            effective_cache_size = 16000
            random_page_cost = 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.



-- 
With Best Regards,
Petchimuthulingam S

------=_Part_9432_1401870.1206363951061
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

i am using postgresql 8.1.8, <br><br>Following configurations:<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shared_buffers = 5000<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; work_mem = 65536<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; maintenance_work_mem = 65536<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; effective_cache_size = 16000<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; random_page_cost = 0.1<br><br>The cpu is waiting percentage goes upto 50%, and query result comes later,<br><br>i am using normal select query ( select * from table_name ).<br><br>table has more then 6 million records.<br>
<br><br clear="all"><br>-- <br>With Best Regards,<br>Petchimuthulingam S

------=_Part_9432_1401870.1206363951061--