Re: Is this good spec for a PostgreSQL server?

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

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 Richard Broersma Jr 2007-09-19 12:30:16 Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
Previous Message Farhan Mughal 2007-09-19 11:54:09 Re: how to know the current size of a database