From: petchimuthu lingam <spmlingam@gmail.com>
To: pgsql-performance@postgresql.org
Subject: waiting for harddisk
Date: Mon, 24 Mar 2008 18:35:51 +0530
Message-ID: <cd233fc30803240605k2a7ae66w90487449ae07d051@mail.gmail.com> (raw)
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
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: spmlingam@gmail.com
Subject: Re: waiting for harddisk
In-Reply-To: <cd233fc30803240605k2a7ae66w90487449ae07d051@mail.gmail.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