Thread: 8 way Intel Xeon system
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
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.
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..."
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]
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..."