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
