From: The Hermit Hacker <scrappy@hub.org>
To: Brian C. Doyle <bcdoyle@mindspring.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Can PostGreSQL handle 100 user database?
Date: Thu, 30 Nov 2000 13:48:43 -0400 (AST)
Message-ID: <Pine.BSF.4.21.0011301347320.323-100000@thelab.hub.org> (raw)
In-Reply-To: <5.0.2.1.2.20001130113826.082b4ec0@pop.mindspring.com>
Note that this is a Linux limitation ... and even then, I'm not quite sure
how accurate that is anymore ... the *BSDs have supported >2gb file
systems for ages now, and, since IBM supports Linux, I'd be shocked if
there was a 2GB limit on memory, considering alot of IBMs servers support
up to 4 or 8GB of RAM ...
On Thu, 30 Nov 2000, Brian C. Doyle wrote:
> Another thing to rember about PostgreSQL is DB Size vs CPU bits
>
> 8.1 CPU types - 32-bit or 64-bit
> Performance of 32-bit cpu machines will decline rapidly when the database
> size exceeds 5 GigaByte. You can run 30 gig database on 32-bit cpu but the
> performance will be degraded. Machines with 32-bit cpu imposes a limitation
> of 2 GB on RAM, 2 GB on file system sizes and other limitations on the
> operating system. Use the special filesystems for linux made by SGI, IBM or
> HP or ext3-fs to support file-sizes greater than 2 GB on 32-bit linux
> machines.
> For extremely large databases, it is strongly advised to use 64-bit
> machines like Digital Alpha cpu, Sun Ultra-sparc 64-bit cpu, Silicon
> graphics 64-bit cpu, Intel Merced IA-64 cpu, HPUX 64bit machines or IBM
> 64-bit machines. Compile PostgreSQL under 64-bit cpu and it can support
> huge databases and large queries. Performance of PostgreSQL for queries on
> large tables and databases will be several times faster than PostgreSQL on
> 32-bit cpu machines. Advantage of 64-bit machines are that you get very
> large memory addressing space and the operating system can support very
> large file-systems, provide better performance with large databases,
> support much larger memory (RAM), have more capabilities etc..
>
> found at http://www.linuxdoc.org/HOWTO/PostgreSQL-HOWTO-8.html
>
>
> At 02:50 PM 11/30/00 +0000, martin.chantler@convergys.com wrote:
>
>
> >I plan to convert a Foxpro system to client/server - hopefully using
> >PostGreSQL
> >(about 100 tables / 300 mb / 100 users)
> >
> >Firstly I heard a rumour that p-sql doesn't process queries in parellel, i.e.
> >performs them sequentially.
> >Is this true? If so it would surely make it impracticle when more than a few
> >clients are connected
> >I tried this out by running 2 VB programs via ODBC than randomly performed
> >queries - they appeared to work
> >in parallel - however I then started a PSQL session and entered a slow
> >query it
> >appeared to stop the 2 VB programs until
> >it had completed. Anyone got the answer to this???
> >
> >The other question I have is how much memory I should really have to
> >support 100
> >connected clients. There must be a formula / rule of thumb for this?
> >
> >I am hoping I can convince my customer to use postgresql but first I need to
> >convince myself it is up to the job :)
> >I am actually pretty impressed with it so far, its got a lot of functionality
> >that DB2 doesn't have
> >
> >Thanks,
> >
> >M Chantler
> >Southampton
> >
> >
> >
> >--
> >NOTICE: The information contained in this electronic mail transmission is
> >intended by Convergys Corporation for the use of the named individual or
> >entity
> >to which it is directed and may contain information that is privileged or
> >otherwise confidential. If you have received this electronic mail
> >transmission
> >in error, please delete it from your system without copying or forwarding it,
> >and notify the sender of the error by reply email or by telephone
> >(collect), so
> >that the sender's address records can be corrected.
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: scrappy@hub.org, bcdoyle@mindspring.com, pgsql-general@postgresql.org
Subject: Re: Can PostGreSQL handle 100 user database?
In-Reply-To: <Pine.BSF.4.21.0011301347320.323-100000@thelab.hub.org>
References: <5.0.2.1.2.20001130113826.082b4ec0@pop.mindspring.com> <Pine.BSF.4.21.0011301347320.323-100000@thelab.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox