pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Benjamin Krajmalnik <kraj@illumen.com>
To: pgsql-admin@postgresql.org
Subject: New system recommendations
Date: Wed, 26 Apr 2006 19:30:49 -0600
Message-ID: <8511B4970E0D124898E973DF496F9B432515CF@stash.stackdump.local> (raw)

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

 

 

 

view thread (15+ messages)  latest in thread

Message-ID: <8511B4970E0D124898E973DF496F9B432515CF@stash.stackdump.local>
Permalink:  ../8511B4970E0D124898E973DF496F9B432515CF@stash.stackdump.local/
Also on:    postgresql.org/message-id/8511B4970E0D124898E973DF496F9B432515CF@stash.stackdump.local

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: kraj@illumen.com
  Subject: Re: New system recommendations
  In-Reply-To: <8511B4970E0D124898E973DF496F9B432515CF@stash.stackdump.local>
  References: <8511B4970E0D124898E973DF496F9B432515CF@stash.stackdump.local>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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