> 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
> 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.
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2008-03-24 16:30:11|
|Subject: Re: Turn correlated in subquery into join |
|Previous:||From: petchimuthu lingam||Date: 2008-03-24 13:05:51|
|Subject: waiting for harddisk|