From: Brian C. Doyle <bcdoyle@mindspring.com>
To: pgsql-general@postgresql.org
Subject: Re: Can PostGreSQL handle 100 user database?
Date: Thu, 30 Nov 2000 11:41:33 -0500
Message-ID: <5.0.2.1.2.20001130113826.082b4ec0@pop.mindspring.com> (raw)
In-Reply-To: <852569A7.005198AC.00@notes.cbis.com>
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.
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: bcdoyle@mindspring.com, pgsql-general@postgresql.org
Subject: Re: Can PostGreSQL handle 100 user database?
In-Reply-To: <5.0.2.1.2.20001130113826.082b4ec0@pop.mindspring.com>
References: <852569A7.005198AC.00@notes.cbis.com> <5.0.2.1.2.20001130113826.082b4ec0@pop.mindspring.com>
* 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