Need advice on best system to choose
Hi,
I am trying to make a decision in choose between these following servers:
1) HP DL 380 G4
Intel Xeon 3.2GHZ 2MB cache
8 GB Ram
RAID -1 73GB SCSI 10K RPM (for OS)
Raid -1 300GB SCSI 10K RPM (data)
2) Sunfire X4150
Intel Xeon E5450 @ 3.0 GHZ 6MB cache
4GB RAM
RAID-1 73 GB SAS 10K RPM (for OS)
RAID -1 146 GB SAS 10K RPM
the database will be update on a hourly basis.
The data consist of mostly of floating point data on which complex
calculates will be performed on it. These calculations will be performed
and inserted into materialized views instead of on a perquerybasis. The
only addition calculation that will be performed during queries would be
aggregation calculations such as averges, sums,etc..
The current database size is currently 70GB, with largest table 16GB
I welcome your advice on choosing between these systems
Regards,
Kenroy
On 3/23/2013 4:03 PM, Kenroy Bennett wrote:
I welcome your advice on choosing between these systems
those are both obsolete systems several generations old. The HP DL
stuff is g7 or g8 now, not g4. that sunfire is newer, but doesn't have
much ram, at least by modern database server standards.
your system description didn't include the all important performance
requirements. "the database will be update on a hourly basis." ...
does that mean 1 row is updated every hour? some sized batch of new
data is inserted? or the whole database is wiped and rebuilt? or
what? most of my databases are undergoing constant updates/inserts
of new data on a steady basis, so we measure things in terms of
transactions/second, with an understanding of the approximate size of
each transaction.
the CPUs in that DL380G4 are late Pentium-4 class, they are the dual
core version of the rather slow 'netburst' architecture. in particular
these weren't all that fast at most floating point type operations.
the E5450, is from the Core 2 Quad generation, so its quite a bit better
than the P4's, but still way behind the Sandy Bridge/Ivy Bridge stuff
--
john r pierce 37N 122W
somewhere on the middle of the left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On a hourly basis 13 tables with number of columns between 50 to 70 columns
are updated with 170 rows.
The tables have a text and timestamps column with other columns being
real.
Kenroy
On Sat, Mar 23, 2013 at 8:40 PM, John R Pierce <pierce@hogranch.com> wrote:
Show quoted text
On 3/23/2013 4:03 PM, Kenroy Bennett wrote:
I welcome your advice on choosing between these systems
those are both obsolete systems several generations old. The HP DL stuff
is g7 or g8 now, not g4. that sunfire is newer, but doesn't have much
ram, at least by modern database server standards.your system description didn't include the all important performance
requirements. "the database will be update on a hourly basis." ... does
that mean 1 row is updated every hour? some sized batch of new data is
inserted? or the whole database is wiped and rebuilt? or what? most
of my databases are undergoing constant updates/inserts of new data on a
steady basis, so we measure things in terms of transactions/second, with an
understanding of the approximate size of each transaction.the CPUs in that DL380G4 are late Pentium-4 class, they are the dual core
version of the rather slow 'netburst' architecture. in particular these
weren't all that fast at most floating point type operations.the E5450, is from the Core 2 Quad generation, so its quite a bit better
than the P4's, but still way behind the Sandy Bridge/Ivy Bridge stuff--
john r pierce 37N 122W
somewhere on the middle of the left coast--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
Import Notes
Reply to msg id not found: CALHXjLN9uhueCMfp=u5eriVKcVF31icbaP6adCK3zeKhxpjMNA@mail.gmail.com
Hi, Kenroy. Can you make a test suite so that you could run a performance
test on each platform? I see you will have different hardware and
operating systems.
Best,
Aleksey
On Sun, Mar 24, 2013 at 11:40 AM, Kenroy Bennett <bennettk9999@gmail.com>wrote:
On a hourly basis 13 tables with number of columns between 50 to 70
columns are updated with 170 rows.
The tables have a text and timestamps column with other columns being
real.Kenroy
On Sat, Mar 23, 2013 at 8:40 PM, John R Pierce <pierce@hogranch.com>wrote:
On 3/23/2013 4:03 PM, Kenroy Bennett wrote:
I welcome your advice on choosing between these systems
those are both obsolete systems several generations old. The HP DL stuff
is g7 or g8 now, not g4. that sunfire is newer, but doesn't have much
ram, at least by modern database server standards.your system description didn't include the all important performance
requirements. "the database will be update on a hourly basis." ... does
that mean 1 row is updated every hour? some sized batch of new data is
inserted? or the whole database is wiped and rebuilt? or what? most
of my databases are undergoing constant updates/inserts of new data on a
steady basis, so we measure things in terms of transactions/second, with an
understanding of the approximate size of each transaction.the CPUs in that DL380G4 are late Pentium-4 class, they are the dual core
version of the rather slow 'netburst' architecture. in particular these
weren't all that fast at most floating point type operations.the E5450, is from the Core 2 Quad generation, so its quite a bit better
than the P4's, but still way behind the Sandy Bridge/Ivy Bridge stuff--
john r pierce 37N 122W
somewhere on the middle of the left coast--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
--
CFEngine Training:
New Jersey, Apr 29 - May 2. http://cf3.eventbrite.com/