[PERFORM] waiting for harddisk

[petchimuthu lingam]

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