Re: Is this good spec for a PostgreSQL server?

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: tv(at)fuzzy(dot)cz
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is this good spec for a PostgreSQL server?
Date: 2007-09-19 12:33:17
Message-ID: 20070919143317.7655d893@laptop-btj
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Well, it isn't really the largest database or the database that need the most performance... At the moment, the
database isn't larger than 15MB and is growing slowly... It is a webapp that is using the database and at the most
(at the moment) there is about 12-14 concurrent users and not much data volume...

We are thinking about this spec. because the web app is a java app, and we need need something that can run java
fast as well as postgresql...

BTJ

On Wed, 19 Sep 2007 14:11:01 +0200
tv(at)fuzzy(dot)cz wrote:

> Hi, you have forgot to note some very important information - what load do you
> expect and what is the size of the database? Is this an upgrade (is the
> database already running somewhere - this would give you some performance
> requirements) or is it a completely new database? Hom nay users / transactions
> do you expect?
>
> Anyway the machine seems quite powerful to me - maybe I'd use more RAM but
> that's easy to do in the future and depends on the size of the dabase. The
> disks seem quite fast, just think about partitioning (raid scheme, where to put
> xlog, etc.)
>
> I guess we have PERC in some of our Dell servers, and it works fine - but I'm
> not sure about the exact type / version as I'm not responsible for the servers.
>
> Tomas
>
> > It's a Dell server with the following spec:
> >
> > PE2950 Quad-Core Xeon E5335 2.0GHz, dual
> > 4GB 667MHz memory
> > 3 x 73GB SAS 15000 rpm disk
> > PERC 5/I Integrated controller card (8 ports, 256MB cache, battery backup) x
> > 6 backplane
> >
> >
> > Is this ok to run PostgreSQL 8.2.x and Tomcat on? And does anyone know if
> > this PERC controller is supported under
> > Linux (not heard of it before...)
> >
> >
> > Regards,
> >
> > BTJ
> >
> > --
> >
> -----------------------------------------------------------------------------------------------
> > Bjørn T Johansen
> >
> > btj(at)havleik(dot)no
> >
> -----------------------------------------------------------------------------------------------
> > Someone wrote:
> > "I understand that if you play a Windows CD backwards you hear strange
> > Satanic messages"
> > To which someone replied:
> > "It's even worse than that; play it forwards and it installs Windows"
> >
> -----------------------------------------------------------------------------------------------
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
> >
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2007-09-19 12:45:43 Re: Is this good spec for a PostgreSQL server?
Previous Message Gregory Stark 2007-09-19 12:32:54 Re: Is this good spec for a PostgreSQL server?