Home
The Toolkit for Online Communities
17508 Community Members, 0 members online, 2234 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Q&A : Postgres and Data Warehouse/Data Mining?

Forum OpenACS Q&A: Postgres and Data Warehouse/Data Mining?

Icon of envelope Request notifications

Collapse
Posted by Louis Gabriel on
Hi,

Anybody have experience with using Postgres for data warehouse/data
mining?  Or know of it's use for such processing?

I'm wondering how it does/would compare to the commercial databases
used for data warehousing & mining.  Especially at what point, if any,
Postgres would simply not be able to scale any higher as to the
volume/size of data to manage and process.

Also, are there any features you think would give Postgres the edge
over a comercial product such as Oracle (besides price).

Moreover, I'm wondering how big a data warehouse/mining situation
Postgres can handle would be; at what point, if any, would one
**have** to go with Oracle, DB2 or whatever.

Thanks!

Louis

Collapse
Posted by Talli Somekh on
Well Louis, if you're looking to be convinced that PG is good, you came to the right place!

From what I understand, PG is capable of handling *msssive* amounts of data. It's been primarily used by researchers and scientists to hold huge datasets for things like astronomical data. So I imagine that you will find it rather effective for many things that you would need it for.

Others can fill you in with more detailed arguments.

talli