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: | Raw Message | Whole Thread | 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 |