Re: Can PostGreSQL handle 100 user database? - Mailing list pgsql-general

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