Re: Where is my bottleneck?

Hi, Michael,

Michael Stone wrote:

>>   I have a performance problem and I don't know where is my bottleneck.
>
> [snip]
>
>>   Most of the time the idle value is even higher than 60%.
>
> It's generally a fairly safe bet that if you are running slow and your
> cpu is idle, your i/o isn't fast enough.

Or the query is misoptimized (low work_mem, missing indices) and cause
much more I/O than necessary.

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org