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.
-
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
