Postgres Pro
Downloads
Home   >   mailing lists

Thread: ...

...

From
"Ashley T. Howes"
Date:
I was wondering if PostgreSQL takes advantage of multiple CPUs when
placed in a single Linux box.  Or are multiple CPUs utilised as long
as the Linux kernel is compiled to take advantage of them?


Ashley

JDBC locale help needed URGENT

From
Tony Grant
Date:
Hello,

If someone could please point me to some information on how to get
accentuated caracteres out of a database with JDBC I would be most
greatfull.

Do I just bang in aLocale = new Locale("fr", "FR");

at the top of my query page?

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html

Re:

From
Doug McNaught
Date:
"Ashley T. Howes" <ashley@turton.com> writes:

> I was wondering if PostgreSQL takes advantage of multiple CPUs when
> placed in a single Linux box.  Or are multiple CPUs utilised as long
> as the Linux kernel is compiled to take advantage of them?

Well, obviously you need an SMP kernel.

Since the PG backend is one process per client, multiple CPUs will
definitely help for multiple clients connecting.  They won't help with
queries for a single client, as there is currently no code to split up
the queries and run the parts on different CPUs.

-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time...          --Dylan

Re:

From
Matthew Hixson
Date:
On Wed, 25 Apr 2001, Ashley T. Howes wrote:

> I was wondering if PostgreSQL takes advantage of multiple CPUs when
> placed in a single Linux box.  Or are multiple CPUs utilised as long
> as the Linux kernel is compiled to take advantage of them?

If you compile an SMP kernel Linux will balance processes and threads
evenly across the CPUs.  One client hitting the database may not see a
huge advantage of a multi-processor machine, but the Linux box is also
running other processes than the postmaster, even if its the kernel
itself.  Of course, if two clients hit the box at the same time then each
postgres backend process could execute on a different CPU.  For a heavily
loaded machine I think you would see a measurable difference in using an
multi-proc box.
  -M@