pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
8 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