Skip site navigation (1) Skip section navigation (2)

need suggestion for server sizing

From: Havasvölgyi Ottó <h(dot)otto(at)freemail(dot)hu>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: need suggestion for server sizing
Date: 2005-06-10 21:12:56
Message-ID: 008601c56e01$2c114880$b000a8c0@OTTO (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
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



In response to

Responses

pgsql-novice by date

Next:From: Celia McInnisDate: 2005-06-11 00:57:37
Subject: accessing data from other databases?
Previous:From: Ennio-SrDate: 2005-06-09 23:18:19
Subject: Re: How not to display system tables?

pgsql-performance by date

Next:From: Clark SlaterDate: 2005-06-11 00:07:57
Subject: Re: faster search
Previous:From: Steve AtkinsDate: 2005-06-10 20:12:40
Subject: Re: faster search

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group