Re: Can PostGreSQL handle 100 user database - more info

we're running ~189 backend processes right now witha loadavg on the
machine of about 89 *rofl* our bottleneck riht now appears to actually be
in disk I/O though, which we are working on by moving from multiple
spindles, multiple file systems over to multiple spindles, stripe'd file
system, so that load is better distributed ...

it can run multiple queries in parrellel, as parrallel as the operating
system itself will allow ... but your bottleneck will generally be:

disk first, memory second and cpu third ... so watch and correct
in that order ... basically, you want to be able to move from disk->memory
as fast as possible, and the more you can store in memory, the less the
CPUs have to wait for the data ...

On Thu, 30 Nov 2000 martin(dot)chantler(at)convergys(dot)com wrote:

>
>
> Thanks for responding,
>
> I suppose what I was really asking is if PostGreSQL works 'as good' as
> other databases like Oracle. The rumour I heard implied that I would have
> problems trying to run PostGreSQL with a lot of clients
>
> As for the queries:
> I have a 6000 record customer file and a bigger file containing orders
> The VB programs randomly retrieved records with a like clause on the first
> letter of the customer name
> E.G. B%, F%, Z%. This SQL also had a join to the order file and returned a few
> hundered records at a time
> The slow SQL I entered simply returned the MAX value for a column in the order
> file. This did seem to lock things
> down, perhaps p-sql was just being cautious or maybe it just slowed everything
> down quite a lot?
>
> Thanks a lot,
>
> M Chantler
>
>
>
> --
> 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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org