Thread: 8 way Intel Xeon system

8 way Intel Xeon system

From
"Castle, Lindsay"
Date:
Hi all,

Hopefully a quick query.

Is there anything special I should look at when configuring either
PostgreSQL and Linux to work together on an 8-way Intel P-III based system?

I currently have the database system running fairly nicely on a 2 CPU
Pentium-II 400 server with 512MB memory, hardware RAID with 32MB cache on
the controllers, unfortunately the db file systems are RAID-5 but I am not
in a position to change that.

I'm mainly interested in what I should concentrate on from a
Linux/PostgreSQL config point of view to see if we can take advantage of the
extra CPUs. - Yes it's overkill but this is a piece of surplus hardware we
don't have to buy.

Perhaps some may say Linux isn't the best option for an 8 CPU server but
this is what I have to work with for reasons we won't get into :-)

The current usage is along the lines of a few thousands updates spread over
the space of a few hours in the morning then followed by a thousand select
queries to do some reporting.

The server also runs an apache web server for people to access but is only
used to view html files on a fairly ad-hoc basis, nothing serious on the web
side of things.

Currently RedHat 9 with PostgreSQL 7.3.2 installed.

Thanks for your time

Linz

Re: 8 way Intel Xeon system

From
"Shridhar Daithankar"
Date:
On 27 Aug 2003 at 14:07, Castle, Lindsay wrote:
> I'm mainly interested in what I should concentrate on from a
> Linux/PostgreSQL config point of view to see if we can take advantage of the
> extra CPUs. - Yes it's overkill but this is a piece of surplus hardware we
> don't have to buy.

First of all whatever you do, add multiple connections using a middle layer.
That will keep your CPU busy.

Of course there are few things need to be done over single connection but this
should help at least in some scenarios.

> Perhaps some may say Linux isn't the best option for an 8 CPU server but
> this is what I have to work with for reasons we won't get into :-)

I think if you can afford a performance benchmark trial, give 2.6.0-testx a
try. They should be much better than 2.4.x.

> The current usage is along the lines of a few thousands updates spread over
> the space of a few hours in the morning then followed by a thousand select
> queries to do some reporting.

In case of such IO intensive and update/delete heavy load, might be a good idea
to move WAL to a separate SCSI channel. I believe merely moving it to another
drive would not yield as much boost.

> Currently RedHat 9 with PostgreSQL 7.3.2 installed.

Get 7.4CVS head. and don't forget to use a autovacuum daemon. It's in contrib
dir.

HTH

Bye
 Shridhar

--
Ogden's Law:    The sooner you fall behind, the more time you have to catch up.


Re: 8 way Intel Xeon system

From
Tomka Gergely
Date:
2003-08-27 ragyogó napján Castle, Lindsay ezt üzente:

> Perhaps some may say Linux isn't the best option for an 8 CPU server but
> this is what I have to work with for reasons we won't get into :-)

This is not true, 2.4 series AFAIK run nicely on these monstrums. If you
want some thrill, try 2.6-test series. Linux Is Good For You (tm) :)

--
Tomka Gergely
"S most - vajon barbárok nélkül mi lesz velünk?
Ők mégiscsak megoldás voltak valahogy..."



Re: 8 way Intel Xeon system

From
Christopher Browne
Date:
After a long battle with technology,tomka@zeus.gau.hu (Tomka Gergely), an earthling, wrote:
> 2003-08-27 ragyogó napján Castle, Lindsay ezt üzente:
>> Perhaps some may say Linux isn't the best option for an 8 CPU
>> server but this is what I have to work with for reasons we won't
>> get into :-)
>
> This is not true, 2.4 series AFAIK run nicely on these monstrums. If
> you want some thrill, try 2.6-test series. Linux Is Good For You
> (tm) :)

The other "bleeding edge" that it'll be interesting to see, um,
"coagulate," is Dragonfly BSD, which plans to do some really
interesting SMP stuff as a fork of FreeBSD...
--
let name="cbbrowne" and tld="ntlug.org" in String.concat "@" [name;tld];;
http://www.ntlug.org/~cbbrowne/nonrdbms.html
"People  are more  vocally opposed  to fur  than leather  because it's
easier to harass rich women than motorcycle gangs." [bumper sticker]

Re: 8 way Intel Xeon system

From
Tomka Gergely
Date:
2003-08-27 ragyogó napján Christopher Browne ezt üzente:

> After a long battle with technology,tomka@zeus.gau.hu (Tomka Gergely), an earthling, wrote:
> > 2003-08-27 ragyogó napján Castle, Lindsay ezt üzente:
> >> Perhaps some may say Linux isn't the best option for an 8 CPU
> >> server but this is what I have to work with for reasons we won't
> >> get into :-)
> >
> > This is not true, 2.4 series AFAIK run nicely on these monstrums. If
> > you want some thrill, try 2.6-test series. Linux Is Good For You
> > (tm) :)
>
> The other "bleeding edge" that it'll be interesting to see, um,
> "coagulate," is Dragonfly BSD, which plans to do some really
> interesting SMP stuff as a fork of FreeBSD...

As isee the pages (what a beautiul insect:) tehy not reach te limit of
useability - or i am wrong?

--
Tomka Gergely
"S most - vajon barbárok nélkül mi lesz velünk?
Ők mégiscsak megoldás voltak valahogy..."