Hi, With some help and supports from people in this mailing list I was able to set up and run Ingres2006 successfully -- many thanks!!
Currently, I have been trying to set up Ingres2006 to be able to perform parallel query across multiple machine but I am not successful yet. I would like to be able to create a table by horizontally partitioning across different physical locations (I have a cluster of x86 64-bit linux machines). The application I am running is heavily query-intensive -- a data mining application (I am not concerned about high availability and the speed of updating database) and we would like to benefit from querying multiple machines in parallel in addition to parallel querying using multiple CPUs on the same machine and assembling the results from those machines. I have the following questions: 1. Is it possible at all to use Ingres2006 to do the task described above? I have been reading the SQL guide and found the example of partitioning a table across different locations but I am not quite sure whether if the table is partitioned across different machines, when I use SQL statement, the results will be automatically assembled correctly? 2. I understand that I have to install and configure Ingres Net with Distributed Option. I have been reading the Distributed Option user guide but it seems like the guide describes mostly about distributed database where different tables are located across different machines, it doesn't mention much about partitioning. I would like to make sure that configuring Ingres Net with Distributed Option will enable the task described above. Once I configure Ingres Net with distributed option properly, I should be able to create a distributed database that have tables partitioned across several physical locations, right? I understand that I do not need the cluster solution or high availability configuration (and I understand that the cluster solution is not fully supported yet?) 3. Last but not least, I just noticed earlier today that Ingress 2006 Community Edition for Linux X86 64-bit machine is not available anymore but it is still available as the Certified Edition. What 's happened? Any suggestions would be highly appreciated. Regards, Natthapol
_______________________________________________ Users mailing list [email protected] http://lists.ingres.com/mailman/listinfo/users
