Re: waiting for harddisk - Mailing list 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.