This is how multiprocessor systems work. You will benefit from the second
processor when you run another query in paralell. There is no way as far as I
am aware to run single task on both processors (except maybe by using threads?)
By the way, Intel processor's Hyperthreading provides not two CP
Bruce Momjian <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] said:
> 1) Can someone explain how postgreSQL uses memory so that I can
> understand
> what I should be doing here.
> BTW, I am running postgres with -B 884. Can someone also explain how
> postgres uses shared mem so that I can have a cl
