X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 39DDE11F60E3 for ; Wed, 26 Apr 2006 22:31:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 27740-06 for ; Wed, 26 Apr 2006 22:30:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from stash.illumen.com (unknown [64.207.29.137]) by postgresql.org (Postfix) with ESMTP id 2CD6011F61E8 for ; Wed, 26 Apr 2006 22:30:48 -0300 (ADT) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6699A.3725129D" Subject: New system recommendations X-MimeOLE: Produced By Microsoft Exchange V6.5 Date: Wed, 26 Apr 2006 19:30:49 -0600 Message-ID: <8511B4970E0D124898E973DF496F9B432515CF@stash.stackdump.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: New system recommendations Thread-Index: AcZpmjbnSkDH/jh/SiGuBR+AGSjKWg== From: "Benjamin Krajmalnik" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/295 X-Sequence-Number: 21464 This is a multi-part message in MIME format. ------_=_NextPart_001_01C6699A.3725129D Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I am about to take a system from testing into production. The system is a combination oltp/bi (network monitoring platform). We are currently inserting about 1 million rows per day, and will increase to probably 5 million once it goes into full deployment. The current test production server is running Windows Server 2003, PostgreSQL 8.1.3. Record insertion is done via an ODBC call to a stored procedure from a Windows based host monitor. =20 In addition to PostgreSQL, the server also runs Apache/PHP for the GUI which displays our dashboards with the querying and drill-down front end.. =20 It is currently running on a 3GHz Xeon HT, 2GB RAM, dual 72GB disks running RAID 1. This server is a 1U without only 2 drive bays, so I have a potential issue with drive space. As a result, I will be moving the db server to a Dell 1650 with 3 146GB SCSI drives running RAID 0. System is a dual processor, 1.2GHz, with 4GB RAM. =20 Due to the amount of record insertions being performed, record insertion speed is paramount - also because excessive execution time will have a side effect of causing the monitoring agent to go stale. Some of the users have mentioned that I will get better performance running under a *nix OS. We are mostly a Microsoft OS house, but also run FreeBSD. I am considering deploying with FreeBSD 6.0. I was wondering if anyone has benchmarks showing speed of execution of PostgreSQL 8.1.3 under Win2003 and FreeBSD 6.0. Also, are there any caveats or items I should be aware of if running under FreeBSD? Any issues when running under a multi-processor kernel? Anything in specific which I should include in the kernel build to give me optimum performance for running PostgreSQL? =20 Needless to say, I am a bit nervous of moving to FreeBSD since I have not tested it in a production environment. =20 Any advice will be deeply appreciated. =20 Regards, =20 Benjamin =20 =20 =20 ------_=_NextPart_001_01C6699A.3725129D Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I am about to take a system from testing into = production.

The system is a combination oltp/bi (network = monitoring platform).

We are currently inserting about 1 million rows per = day, and will increase to probably 5 million once it goes into full = deployment.

The current test production server is running Windows = Server 2003, PostgreSQL 8.1.3.

Record insertion is done via an ODBC call to a stored procedure from a Windows based host = monitor.

 

In addition to PostgreSQL, the server also runs = Apache/PHP for the GUI which displays our dashboards with the querying and = drill-down front end..

 

It is currently running on a 3GHz Xeon HT, 2GB RAM, = dual 72GB disks running RAID 1.  This server is a 1U without only 2 = drive bays, so I have a potential issue with drive = space.

As a result, I will be moving the db server to a Dell = 1650 with 3 146GB SCSI drives running RAID 0.  System is a dual = processor, 1.2GHz, with 4GB RAM.

 

Due to the amount of record insertions being = performed, record insertion speed is paramount – also because excessive = execution time will have a side effect of causing the monitoring agent to go = stale.  Some of the users have mentioned that I will get better performance = running under a *nix OS.  We are mostly a Microsoft OS house, but also run FreeBSD.  I am considering deploying with FreeBSD 6.0.  I was wondering if anyone has benchmarks showing speed of execution of = PostgreSQL 8.1.3 under Win2003 and FreeBSD 6.0.  Also, are there any caveats = or items I should be aware of if running under FreeBSD?  Any issues when = running under a multi-processor kernel?  Anything in specific which I = should include in the kernel build to give me optimum performance for running PostgreSQL?

 

Needless to say, I am a bit nervous of moving to = FreeBSD since I have not tested it in a production = environment.

 

Any advice will be deeply = appreciated.

 

Regards,

 

Benjamin

 

 

 

------_=_NextPart_001_01C6699A.3725129D--