X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BD5925284D for ; Fri, 10 Jun 2005 18:13:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43669-08 for ; Fri, 10 Jun 2005 21:12:58 +0000 (GMT) Received: from viefep11-int.chello.at (viefep11-int.chello.at [213.46.255.27]) by svr1.postgresql.org (Postfix) with ESMTP id 3B6085281E for ; Fri, 10 Jun 2005 18:12:55 -0300 (ADT) Received: from OTTO ([213.222.172.216]) by viefep11-int.chello.at (InterMail vM.6.01.04.04 201-2131-118-104-20050224) with SMTP id <20050610211256.PEHD1768.viefep11-int.chello.at@OTTO> for ; Fri, 10 Jun 2005 23:12:56 +0200 Message-ID: <008601c56e01$2c114880$b000a8c0@OTTO> From: =?iso-8859-1?Q?Havasv=F6lgyi_Ott=F3?= To: References: <20050418174701.BDD1219007F@arica.terra.com.br> Subject: need suggestion for server sizing Date: Fri, 10 Jun 2005 23:12:56 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200506/63 X-Sequence-Number: 13656 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