| From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Johan Segernäs <johan(dot)segernas(at)foretagsuniversitetet(dot)se> |
| Cc: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Performance |
| Date: | 2001-02-05 10:21:06 |
| Message-ID: | Pine.LNX.3.96.1010205111239.24877D-100000@ara.zf.jcu.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, 5 Feb 2001, [iso-8859-1] Johan Segernäs wrote:
> And running postgresql on a P133 with 64 meggs of RAM using debian woody.
> How many users will that box be able to serve?
>
> I'm running apache/php on another machine and the database will have
> questions and answers for some exams in it. Nothing hard, just text.
Depends on:
- RAM
- I/O operations (do you run UPDATE, INSERT very often?)
- fsync() setting (-F or 7.1)
- size of DB
- size of data transfered between client-server
- number of used tables in typical query
- and more and more.. :-)
..cca you need for each connected client 2Mb + x RAM (where 'x'
depend on processed data). Not is problem create table and write query
that spend all your memory.
Karel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johan Segernäs | 2001-02-05 11:21:56 | RE: Performance |
| Previous Message | Johan Segernäs | 2001-02-05 09:59:55 | Performance |