From: Havasvölgyi Ottó <h.otto@freemail.hu>
To: pgsql-novice@postgresql.org
Subject: need suggestion for server sizing
Date: Fri, 10 Jun 2005 23:12:56 +0200
Message-ID: <008601c56e01$2c114880$b000a8c0@OTTO> (raw)
References: <20050418174701.BDD1219007F@arica.terra.com.br>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: h.otto@freemail.hu, pgsql-novice@postgresql.org
Subject: Re: need suggestion for server sizing
In-Reply-To: <008601c56e01$2c114880$b000a8c0@OTTO>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox