agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Johan Segernäs <johan.segernas@foretagsuniversitetet.se>
To: 'Karel Zak' <zakkr@zf.jcu.cz>
Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: RE: Performance
Date: Mon, 5 Feb 2001 12:21:56 +0100
Message-ID: <1AA3DCC66D03D740BE070FB8CB48D9A6D2AD@funsql.fun> (raw)
> 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
64 MB EDO
> - I/O operations (do you run UPDATE, INSERT very often?)
No, very seldom. It'll be for serving questions and check for the right
answer to the question.
We'll only do INSERT/UPDATE when adding users, adding new questions and so
on.
> - fsync() setting (-F or 7.1)
?
> - size of DB
> - size of data transfered between client-server
> - number of used tables in typical query
As I said, it's gonna be for an exam-system with around 150 questions around
100 chars long.
With answers for each and every one.
No big amount of data.
view thread (16+ messages) latest in thread
Message-ID: <1AA3DCC66D03D740BE070FB8CB48D9A6D2AD@funsql.fun>
Permalink: ../1AA3DCC66D03D740BE070FB8CB48D9A6D2AD@funsql.fun/
Also on: postgresql.org/message-id/1AA3DCC66D03D740BE070FB8CB48D9A6D2AD@funsql.fun
reply
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-admin@postgresql.org
Cc: johan.segernas@foretagsuniversitetet.se, zakkr@zf.jcu.cz
Subject: RE: Performance
In-Reply-To: <1AA3DCC66D03D740BE070FB8CB48D9A6D2AD@funsql.fun>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox