Re: slow query - will CLUSTER help? - Mailing list pgsql-performance

From Gavin Flower
Subject Re: slow query - will CLUSTER help?
Date
Msg-id 52B4B459.2090407@archidevsys.co.nz
Whole thread Raw
In response to Re: slow query - will CLUSTER help?  (Shaun Thomas <sthomas@optionshouse.com>)
List pgsql-performance
On 21/12/13 05:11, Shaun Thomas wrote:
[...]
> .
>
> Of course, don't forget to buy modules in multiples of four, otherwise
> you're not taking advantage of all the CPU's memory channels. :)
>
Note some processors have 3 (three) memory channels!  And I know of some
with 4 memory channels.  So it is important to check your processor &
mother board.

The desktop I got when I joined a university on contract had 12GB about
2 years ago.


Cheers,
Gavin


pgsql-performance by date:

Previous
From: Dave Johansen
Date:
Subject: Re: Recommendations for partitioning?
Next
From: David Rowley
Date:
Subject: Re: DATE_TRUNC() and GROUP BY?