Thread: Postgresql / Threads / Scalability
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
Timothy Glover writes: > 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. If that means a lot of concurrent clients you want to get a lot more CPUs it seems. I'm not sure what you consider a huge database but there are instances of databases of far more than 10GB. Big hardware and a better OS will help. -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
On Sun, 5 Mar 2000, Timothy Glover wrote: > 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. datamining! I'm considering doing it. could you please tell us more about it? It's said that mysql is good for this (fast, for datamining, transaction is not a issue), why you do not use it? why not m$sql (simply you are a linux shop?). also, do you use star schema? how do you do the index? thanks in advance!