Postgresql / Threads / Scalability - Mailing list pgsql-general

From Timothy Glover
Subject Postgresql / Threads / Scalability
Date
Msg-id 00fd01bf863c$0681e8c0$82612ecb@greenbank.net.au
Whole thread Raw
Responses Re: [GENERAL] Postgresql / Threads / Scalability
Re: [GENERAL] Postgresql / Threads / Scalability
List pgsql-general
Hi,
Im very new to this list please excuse me if ive posted to the wrong place.
I was just wondering if postgresql has support for SMP/threads ?
I was also wondering how scalable it is ?

At work we are considering whether to switch to oracle or continue with
postgresql.
We currently use postgresql, with no problems and excellent response time
(with data mining).
But we are wondering what happens when the database gets huge.
Currently its run on a p3/300 with 198 megs of ram, and it services 80
hospital locations.

Im considering a larger p3, with alot more ram and with a raid array, or
maybe something like a SunE450 to run it.

Any opinions welcome


Timothy Glover
Network Engineer
Greenbank / Kmtech / Dominion
timg@greenbank.net.au




pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] Transactional logging
Next
From: Jeff Davis
Date:
Subject: How to get table/DB info