| From: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
|---|---|
| To: | Shaun Thomas <sthomas(at)optionshouse(dot)com>, Sev Zaslavsky <sevzas(at)gmail(dot)com>, Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: slow query - will CLUSTER help? |
| Date: | 2013-12-20 21:19:21 |
| Message-ID: | 52B4B459.2090407@archidevsys.co.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2013-12-21 05:46:22 | Re: DATE_TRUNC() and GROUP BY? |
| Previous Message | Dave Johansen | 2013-12-20 16:24:40 | Re: Recommendations for partitioning? |