Neophyte Question: Is Postgres What I Need??

[geovh]

I want multithreaded processing of single queriers. I want multithreaded processing of single genetic alogrithms. I want multithreaded processing of batch queries. I want a single user/single query to be able to take full advantage of the power and speed offered by a multicored multiprocessor server.

The databases will contain 5-20 million records, each with 300 fields. The purpose of the work is to research the occurance of mathematical relationships between the fields. Speed is of the essence.

Sorry about my inexperience with DBMS but feel free to fire away. I'll learn whatever is necessary to get the job done. I just need some help getting pointed in the right direction.

Thanks.

 

[ceco]

http://greenplum.com/products/bizgresMpp.php

 

[geovh]

Thanks ceco. That helped a bunch.

Once I got my bearings from your suggestion, I also found ExtenDB which works with Postgres.

http://www.extendb.com

Do you know anything about its performance? They claim parallel processing with near one to one scaling.

Anyway, thanks again