pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed8 way Intel Xeon system
5+ messages / 4 participants
[nested] [flat]
* 8 way Intel Xeon system
@ 2003-08-27 04:07 Castle, Lindsay <lindsay.castle@eds.com>
0 siblings, 2 replies; 5+ messages in thread
From: Castle, Lindsay @ 2003-08-27 04:07 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: 8 way Intel Xeon system
@ 2003-08-27 07:00 Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
parent: Castle, Lindsay <lindsay.castle@eds.com>
1 sibling, 0 replies; 5+ messages in thread
From: Shridhar Daithankar @ 2003-08-27 07:00 UTC (permalink / raw)
To: pgsql-performance
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: 8 way Intel Xeon system
@ 2003-08-27 08:56 Tomka Gergely <tomka@zeus.gau.hu>
parent: Castle, Lindsay <lindsay.castle@eds.com>
1 sibling, 1 reply; 5+ messages in thread
From: Tomka Gergely @ 2003-08-27 08:56 UTC (permalink / raw)
To: Castle, Lindsay <lindsay.castle@eds.com>; +Cc: pgsql-performance
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..."
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: 8 way Intel Xeon system
@ 2003-08-28 02:49 Christopher Browne <cbbrowne@acm.org>
parent: Tomka Gergely <tomka@zeus.gau.hu>
0 siblings, 1 reply; 5+ messages in thread
From: Christopher Browne @ 2003-08-28 02:49 UTC (permalink / raw)
To: pgsql-performance
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]
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: 8 way Intel Xeon system
@ 2003-08-28 06:55 Tomka Gergely <tomka@zeus.gau.hu>
parent: Christopher Browne <cbbrowne@acm.org>
0 siblings, 0 replies; 5+ messages in thread
From: Tomka Gergely @ 2003-08-28 06:55 UTC (permalink / raw)
To: Christopher Browne <cbbrowne@acm.org>; +Cc: pgsql-performance
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..."
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2003-08-28 06:55 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-27 04:07 8 way Intel Xeon system Castle, Lindsay <lindsay.castle@eds.com>
2003-08-27 07:00 ` Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
2003-08-27 08:56 ` Tomka Gergely <tomka@zeus.gau.hu>
2003-08-28 02:49 ` Christopher Browne <cbbrowne@acm.org>
2003-08-28 06:55 ` Tomka Gergely <tomka@zeus.gau.hu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox