Message-ID: <008d01c570fe$7882f6a0$b000a8c0@OTTO>
From: =?ISO-8859-1?Q?Havasv=F6lgyi_Ott=F3?= <h.otto@freemail.hu>
To: <pgsql-novice@postgresql.org>
References: <20050418174701.BDD1219007F@arica.terra.com.br>
	<008601c56e01$2c114880$b000a8c0@OTTO>
	<E1EE5F72-545F-441C-BBEA-0C52B2BD4ECB@yale.edu>
Subject: Re: need suggestion for server sizing
Date: Tue, 14 Jun 2005 18:31:09 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit

Janos,

Thank you. Sorry, but I wanted to install Linux on the server, I haven't
mentioned it. I am not that familiar in the server-world. So, what
configuration is enough on X86 (32 bit) architecture for PostgreSQL with the
conditions listed in my previous post?

Thanks,
Otto


----- Original Message ----- 
From: "János" <janos.lobb@yale.edu>
To: "Havasvölgyi Ottó" <h.otto@freemail.hu>
Cc: <pgsql-novice@postgresql.org>
Sent: Monday, June 13, 2005 3:25 PM
Subject: Re: [NOVICE] need suggestion for server sizing


Any XServe from Apple will do it.

János
On Jun 10, 2005, at 5:12 PM, Havasvölgyi Ottó wrote:

> Hi all,
>
> I need your help to determine the configuration of a server
> machine, and the
> PG DBMS.
> There will be not more than 25 concurrent users. They will use a
> business
> software that accesses tha database. The database will be not that
> large, it
> seems that none of the tables's recordcount will exceed 1-2
> million, but
> there will be a lot of small (<5000 record) tables. The numbert of
> tables
> will be about 300. What server would you install to such a site to
> make the
> database respond quickly in any case?
> I would like to leave fsync on.
> Perhaps you need some additional information. In this case just
> indicate it.
>
> Thanks in advance,
> Otto
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that
> your
>       message can get through to the mailing list cleanly
>


------------------------------------------
"There was a mighty king in the land of the Huns whose goodness and
wisdom had no equal."
Nibelungen-Lied


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match