From: PFC <lists@peufeu.com>
To: petchimuthu lingam <spmlingam@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: waiting for harddisk
Date: Mon, 24 Mar 2008 14:20:56 +0100
Message-ID: <op.t8ivc6adcigqcu@apollo13.peufeu.com> (raw)
In-Reply-To: <cd233fc30803240605k2a7ae66w90487449ae07d051@mail.gmail.com>
References: <cd233fc30803240605k2a7ae66w90487449ae07d051@mail.gmail.com>
> 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.
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.
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: lists@peufeu.com, spmlingam@gmail.com
Subject: Re: waiting for harddisk
In-Reply-To: <op.t8ivc6adcigqcu@apollo13.peufeu.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