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 194A111F6629 for ; Thu, 27 Apr 2006 19:30:59 -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 47717-03 for ; Thu, 27 Apr 2006 19:30:46 -0300 (ADT) X-Greylist: delayed 00:18:43.027173 by SQLgrey- Received: from teamadr.net (adr2.teamadr.com [209.216.238.173]) by postgresql.org (Postfix) with ESMTP id 4C73711F6618 for ; Thu, 27 Apr 2006 19:30:41 -0300 (ADT) Received: from [10.0.70.36] [66.15.147.72] by teamadr.net with ESMTP (SMTPD32-8.15) id A1BF49F0244; Thu, 27 Apr 2006 15:12:15 -0700 Message-ID: <44514192.2010909@teamadr.com> Date: Thu, 27 Apr 2006 15:11:30 -0700 From: brian User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050715) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: New system recommendations References: <8511B4970E0D124898E973DF496F9B432515CF@stash.stackdump.local> <20060427050605.GW97354@pervasive.com> In-Reply-To: <20060427050605.GW97354@pervasive.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/317 X-Sequence-Number: 21486 Jim C. Nasby wrote: > On Wed, Apr 26, 2006 at 07:30:49PM -0600, Benjamin Krajmalnik wrote: > >> 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. >> > > Make sure you're batching inserts with transactions. > > >> 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. >> > > 3 drive raid0 is likely to fail within 3-4 years, just so you know; > unless it's not new hardware, in which case I'd expect something closer > to 2 years (my general experience is that server HDs will last 4-6 > years, so with 3 of them you're looking at a failure every ~2 years). > You sure you want to trust a monitoring app to raid0? :) > > >> 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. >> > > Aside from some very large shops running FreeBSD (yahoo does I believe, > and hotmail did for a long time, even after MS bought it), it's also a > preferred OS by PostgreSQL developers. On the other hand we've only had > Windows support for about 2 years and there's known windows-only issues. > Not certain about freebsd 6.x, but on 4.x, running an intel SMP build limits each machine to three and a half gigs of memory: FreeBSD 5.4-STABLE #0: Fri Sep 2 11:32:58 PDT 2005 Timecounter "i8254" frequency 1193182 Hz quality 0 CPU: Intel(R) Xeon(TM) CPU 3.06GHz (3056.50-MHz 686-class CPU) Origin = "GenuineIntel" Id = 0xf27 Stepping = 7 Features=0xbfebfbff Hyperthreading: 2 logical CPUs real memory = 3759144960 (3585 MB) avail memory = 3679334400 (3508 MB) There is 4 gigs of physical memory in the machine that produced the above. PAE cannot be built into this kernel... I can't even remember what the error was.. I think PAE ended up being incompatible with HTT. -Brian