Skip site navigation (1) Skip section navigation (2)

Re: waiting for harddisk

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 (view raw or flat)
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.

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2008-03-24 16:30:11
Subject: Re: Turn correlated in subquery into join
Previous:From: petchimuthu lingamDate: 2008-03-24 13:05:51
Subject: waiting for harddisk

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group