I am using PostgreSQL 8.4. I really like the new unsest () and array_agg () functions; it's about the time when they realize the dynamic processing potential of their arrays!
Anyway, I am working on the ends of a web server that use long arrays a lot. There will be two consecutive processes, each of which will occur on a different physical machine. Each such process is a lightweight python application that “manages” SQL database queries on each of its machines, as well as front-end queries.
The first process will generate an array that will be buffered into the SQL table. Each such generated array is accessible through a primary key. When this is done, the first python application sends the key to the second python application. Then the second python application running on another machine uses it to get the found array on the first machine. He then sends it to his own db to generate the final result.
The reason I'm sending the key is because I'm sure this will speed up the process. But in fact, what I would like is a way to get the second database to send a request to the first database in the hope of minimizing the serialization delay, etc.
Any help / advice would be appreciated.
thank