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