| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Celia McInnis | 2005-06-11 00:57:37 | accessing data from other databases? |
| Previous Message | Ennio-Sr | 2005-06-09 23:18:19 | Re: How not to display system tables? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Clark Slater | 2005-06-11 00:07:57 | Re: faster search |
| Previous Message | Steve Atkins | 2005-06-10 20:12:40 | Re: faster search |