Received: from funsql.fun (fw.foretagsuniversitetet.se [212.75.89.162]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f15BOSx97790 for ; Mon, 5 Feb 2001 06:24:28 -0500 (EST) (envelope-from johan.segernas@foretagsuniversitetet.se) Received: by funsql.fun with Internet Mail Service (5.5.2653.19) id ; Mon, 5 Feb 2001 12:22:02 +0100 Message-ID: <1AA3DCC66D03D740BE070FB8CB48D9A6D2AD@funsql.fun> From: =?iso-8859-2?Q?Johan_Segern=E4s?= To: "'Karel Zak'" Cc: "'pgsql-admin@postgresql.org'" Subject: RE: Performance Date: Mon, 5 Feb 2001 12:21:56 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C08F65.D95B92E0" X-Archive-Number: 200102/18 X-Sequence-Number: 618 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C08F65.D95B92E0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable > On Mon, 5 Feb 2001, [iso-8859-1] Johan Segern=E4s wrote: > > And running postgresql on a P133 with 64 meggs of RAM using=20 > debian woody.=20 > > How many users will that box be able to serve?=20 > >=20 > > I'm running apache/php on another machine and the database=20 > will have=20 > > questions and answers for some exams in it. Nothing hard, just text. >=20 > Depends on: >=20 > - 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.=20 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.=20 With answers for each and every one. No big amount of data. ------_=_NextPart_001_01C08F65.D95B92E0 Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable RE: [ADMIN] Performance

> On Mon, 5 Feb 2001, [iso-8859-1] Johan Segern=E4s wr= ote:
> > 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. No= thing hard, just text.
>
>  Depends on:
>
>  - RAM

64 MB EDO

>  - I/O operations (do you run UPDATE, INSERT ve= ry 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 ne= w questions and so on.

>  - fsync() setting (-F or 7.1)

?

>  - size of DB
>  - size of data transfered between client-serv= er
>  - number of used tables in typical query

As I said, it's gonna be for an exam-system with around 1= 50 questions around 100 chars long.
With answers for each and every one.

No big amount of data.

------_=_NextPart_001_01C08F65.D95B92E0--