Le 24 novembre 2011 18:20, MirrorX a écrit :
> hello to all,
>
> i would like your advice on the following matter. i have a table with 150
> million rows. there are some indexes on this table but the one that is
> really important is one that has 3 columns (a,b,c). one application
> constantly mak
On Thu, Nov 24, 2011 at 12:20 PM, MirrorX wrote:
> -32 cores,
> -not cpu bound (the cpu util was about 5% when i performed the tests)
A single query will only use a single CPU.
5% of 32 cores is 100% of 1.6 cores.
Are you sure that the 1 core doing the 1 postgresql query wasn't 100% utilized?