| From: | PFC <lists(at)peufeu(dot)com> |
|---|---|
| To: | "petchimuthu lingam" <spmlingam(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: waiting for harddisk |
| Date: | 2008-03-24 13:20:56 |
| Message-ID: | op.t8ivc6adcigqcu@apollo13.peufeu.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-03-24 16:30:11 | Re: Turn correlated in subquery into join |
| Previous Message | petchimuthu lingam | 2008-03-24 13:05:51 | waiting for harddisk |