Postgres Pro
Downloads
Home   >   mailing lists

Thread: Performance

Performance

From
Johan Segernäs
Date:

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.

Re: Performance

From
Karel Zak
Date:
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

RE: Performance

From
Johan Segernäs
Date:

> 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.

Re: Performance

From
R D
Date:
I think it will do.
I'm developing a web system based on PgSQL. My test
server is Cyrix 166MHz 16MB of RAM. My database has
few tables with over 1 milion rows and one of them has
almost 25 milions. With good indexes I can fetch data
form this table for less than 8-10 seconds.
But it depends on the number of connections and etc.
Your DB is small so my opinion is that your P133 will
do.

Rumen

--- Johan_Segern�s
<johan.segernas@foretagsuniversitetet.se> 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.
>
>


__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35
a year!  http://personal.mail.yahoo.com/