From DLee@mail.maricopa.gov Mon May 17 23:08:59 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 53DFED1B16B; Mon, 17 May 2004 20:08:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 21408-09; Mon, 17 May 2004 20:08:41 -0300 (ADT) Received: from mailbox.maricopa.gov (mailbox.maricopa.gov [156.42.4.109]) by svr1.postgresql.org (Postfix) with ESMTP id 3ECC3D1C4DB; Mon, 17 May 2004 20:08:37 -0300 (ADT) Received: from maricopa_xcng2.maricopa.gov (maricopa_xcng2.maricopa.gov [156.42.103.174] (may be forged)) by mailbox.maricopa.gov (8.8.6 (PHNE_17190)/8.8.6) with ESMTP id QAA25456; Mon, 17 May 2004 16:02:13 -0700 (MST) Received: by maricopa_xcng2 with Internet Mail Service (5.5.2657.72) id ; Mon, 17 May 2004 16:08:38 -0700 Message-ID: <64EDC403A1417B4299488BAE87CA7CBF01CD0E15@maricopa_xcng0> From: Duane Lee - EGOVX To: "PG General (E-mail)" , "PGADMIN (E-mail)" , "PSQL Performance (E-mail)" Subject: Hardware Platform Date: Mon, 17 May 2004 16:08:34 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C43C63.E0BF5180" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200405/169 X-Sequence-Number: 13485 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C43C63.E0BF5180 Content-Type: text/plain; charset="iso-8859-1" I'm working on a project using PostgreSQL as our database designing a budget system. We are still in the design and testing phases but I thought I would ask advice about a platform to host this system. We aren't a large system, probably no more than 50-75 users at any one time. >From a data standpoint I can't guess at the number of gigabytes but suffice to say it is not going to be that large. Our biggest table will probably hold about 1 million rows and is about 120 bytes (closer to about 100). Dell and HP servers are being mentioned but we currently have no preference. Any help you could provide will be appreciated. Thanks, Duane P.S. I've only just begun using PostgreSQL after having used (and still using) DB2 on a mainframe for the past 14 years. My experience with Unix/Linux is limited to some community college classes I've taken but we do have a couple of experienced Linux sysadmins on our team. I tell you this because my "ignorance" will probably show more than once in my inquiries. ------_=_NextPart_001_01C43C63.E0BF5180 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hardware Platform

I'm working on a project using PostgreSQL as our database= designing a budget system.  We are still in the design and testing ph= ases but I thought I would ask advice about a platform to host this system.=

We aren't a large system, probably no more than 50-75 use= rs at any one time.  From a data standpoint I can't guess at the numbe= r of gigabytes but suffice to say it is not going to be that large.  O= ur biggest table will probably hold about 1 million rows and is about 120 b= ytes (closer to about 100).

Dell and HP servers are being mentioned but we currently = have no preference.

Any help you could provide will be appreciated.

Thanks,
Duane

P.S. I've only just begun using PostgreSQL after having u= sed (and still using) DB2 on a mainframe for the past 14 years.  My ex= perience with Unix/Linux is limited to some community college classes I've = taken but we do have a couple of experienced Linux sysadmins on our team.&n= bsp; I tell you this because my "ignorance" will probably show mo= re than once in my inquiries.

------_=_NextPart_001_01C43C63.E0BF5180-- From marty@outputservices.com Thu May 20 13:46:24 2004 X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 346BFD1B182 for ; Thu, 20 May 2004 10:46:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 48136-05 for ; Thu, 20 May 2004 10:46:07 -0300 (ADT) Received: from outputservices.com (outputt1130.customer.frii.net [216.17.159.130]) by svr1.postgresql.org (Postfix) with ESMTP id 63DAED1B459 for ; Thu, 20 May 2004 10:46:03 -0300 (ADT) Received: from outputservices.com (outputservices.com [137.106.76.15]) by outputservices.com (8.11.3/8.11.3) with ESMTP id i4KDk8417619 for ; Thu, 20 May 2004 07:46:08 -0600 (MDT) Message-ID: <40ACB6A0.3070802@outputservices.com> Date: Thu, 20 May 2004 07:46:08 -0600 From: Marty Scholes User-Agent: Mozilla/5.0 (X11; U; SunOS sun4u; en-US; rv:0.9.9) Gecko/20020517 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Hardware Platform Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/172 X-Sequence-Number: 7003 Duane wrote: > P.S. I've only just begun using PostgreSQL after having > used (and still using) DB2 on a mainframe for the past 14 > years. My experience with Unix/Linux is limited to some > community college classes I've taken but we do have > a couple of experienced Linux sysadmins on our team. > I tell you this because my "ignorance" will probably > show more than once in my inquiries. Duane, If you've been actively using and developing in DB2, presumably under MVS or whatever big blue is calling it these days, for 14 years, then you will bring a wealth of big system expertise to Pg. Please stay involved and make suggestions where you thing Pg could be improved. Marty