Re: Can PostGreSQL handle 100 user database?

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(dot)chantler(at)convergys(dot)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.