what's best: opteron or xeon for pg 7.4.3?

Rocael Hernandez

Hello all,
I was wondering what's best for PG, since we have to
decide what will be the new server for our DB, that
will serve one or more websites.

Our actual configuration is a dual xeon 2.8ghz with
4Gb ram + scsi disks, and works fine, though some
intensive insert/update processes has taken it to 100%
cpu use.

Does using an opteron server has advantages against a
xeon?
I'm thinking in a dual opteron 248 with 4Gb ran +
scsi...

Suggestions and your experience on this is very
welcomed!

_______________ _______________ ____
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1

Subscribe Reply

1544

Chris Browne

ro*****@yahoo.c om (Rocael Hernandez) writes:

Hello all, I was wondering what's best for PG, since we have to
decide what will be the new server for our DB, that will serve one
or more websites.

Our actual configuration is a dual xeon 2.8ghz with 4Gb ram + scsi
disks, and works fine, though some intensive insert/update processes
has taken it to 100% cpu use.

Does using an opteron server has advantages against a xeon? I'm
thinking in a dual opteron 248 with 4Gb ran + scsi...

Suggestions and your experience on this is very welcomed!

You're sitting right at the point at which Xeon should be able to look
its best.

The *big* win of Opteron is in supporting >4GB of memory; doing that
is what starts making Xeon look _very bad_.

There's also an issue where spinlocks get to be troublesome on Xeons
with > 2 processors; you're again at the point where Xeon is at about
its best.

If you need anything more, then Opteron should be able to scale up,
while Xeon will more than likely slow down.
--
let name="cbbrowne" and tld="cbbrowne.c om" in String.concat "@" [name;tld];;
http://www3.sympatico.ca/cbbrowne/finances.html
In case you weren't aware, "ad homineum" is not latin for "the user of
this technique is a fine debater." -- Thomas F. Burdick

Nov 23 '05 #2

Similar topics

1430

Question about MySQL performance on 2 and 4 CPU Opteron machines

by: jacob nikom | last post by:

Hi, We ran MySQL (4.0.15-standard, 64-bit, SuSe 8.0) benchmarks on 2 CPU and 4 CPU Opteron machines. Mostly we tested insertion times with many simultaneous connections (hundreds). To our surprise we did not find significant differences. Each of our servers (2 and 4 CPU machine) has one 1Gbit network connection. I have feelings that the machines are the network bounded, not the CPU bounded. Could it be true? How to verify it?

MySQL Database

1156

What hardware to get?

by: grouparchive | last post by:

We are upgrading our SQL Server hardware because we need more CPU power. The current server is a P4 3.2 GHz with HT. The system we have been looking at is a dual Opteron, and the questions is: will two Opteron 244 (1.8GHz) give considerably more CPU power than a single P4 3.2 GHz? Or would we need to get two Opteron 250 (2.4 GHz) to really get a notable increase in CPU power? The plan is to get single core Operons first and then plug...

Microsoft SQL Server

1876

64 bit python binaries (or builds) for Xeon and Opteron architectures on Windows platforms

by: louis_pastorik | last post by:

Does anyone have any information about 64 bit python support for Xeon and Opteron architectures on Windows platforms? If anyone has built the python runtime on either of these platforms before I would be really interested. Thanks.

Python

1222

DB2 8.1 FP 7 on AMD Opteron

by: J.Haan | last post by:

Hi all, at the company where I work, we're planning on installing DB2 on an AMD Opteron with 32GB of memory. Let's say we're running DB2 8.1 FP 7 in 64bit mode on SuSE Linux Enterprise Server 9.0. Can we create bufferpools with a size over 4GB? Let's say 12GB? Has anyone got any experience running such a configuration?

DB2 Database

2264

SQL Compiler for Linux on AMD/Opteron-64 bit machine

by: ashokrathi | last post by:

I am trying to compile SQL procedures on Linux running on AMD/Opteron 64-bit machine. I have 'gcc', 'cc' and 'g++' compilers on my machine. I have set DB2_SQLROUTINE_COMPILE_COMMAND with various options, such as, db2set DB2_SQLROUTINE_COMPILE_COMMAND="gcc -fPIC -$HOME/sqllib/include SQLROUTINE_FILENAME.c -shared -o SQLROUTINE_FILENAME -L$HOME/sqllib/lib -ldb2" I have tried with/without "-fPIC" option. Without "-fPIC", I get following...

DB2 Database

1193

XEON session timeout

by: Dan Pavel | last post by:

Hi, I am using 3 machines for my web application and 2 of them are XEON platforms. After I login to my aplication, it seems that on the XEONs the session is timeout faster than the other machine. It is possible that the XEON platform to be blamed for this ? Thank you, Dan

C# / C Sharp

9738

Quad Xeon vs. Dual Itanium

by: John Gibson | last post by:

Hi, all. I need to upgrade my dual Xeon PostgreSQL engine. Assuming similar memory and disk sub-systems, I am considering a Quad Xeon system vs. a Dual Itanium for PostgreSQL. I believe that the PostgreSQL code is written for 32 bit and not optimized for the 64 bit Itanium cpu. That makes me think that the Xeon system would be a better choice.

PostgreSQL Database

2340

ThreadPool and Dual Core Opteron.

by: LLessieux | last post by:

Hi, I have been seeing a strange behaviour when doing some tests on a Dual - Dual Core Opteron system using Windows XP (32bits with SP2). In out application we have a wrapper around the thread pool to handle the work on renderers and CPU intensive tasks. On the Dual - Dual Core Opteron, the application is correctly starting 4 threads but it seems to be running only 2 concurrently.

.NET Framework

1987

Index was outside the bonds of the array on framework 2.0 + + Win2003 + Xeon based system

by: gilad.kapel | last post by:

Hi I have a system composed of sevral DLLs all round up into one WebService. I'm working with VS2005 Framework 2.0 under WinXP. The system is at the end of its development stage and was both checked on a WinXP & Win2003 32bit systems on the same computer (Standard P4 - 3GHz with 1Mb of ram)

C# / C Sharp

9590

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10223

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10000

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9866

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8879

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6675

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5310

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5448

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3571

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP