Hi all,
I just installed and tried pgpool. I'm interested in using pgpool to access
different databases with different data (partitioning).
I set up 2 databases that have different data (suppose one db has data with an
id from 1 to 10, the other from 10 to infinite).
Everything seems to work, but I thought that in case I made a query like
SELECT * FROM mytab WHERE ID=2
pgpool would issue that query ONLY to the db having IDs from 1 to 10. But the
query is issued to both DBs.
In other words I thought pgpool could do partition pruning (eliminating
databases that don't partecipate in the results).
Was I wrong? Or I didn't set up pgpool properly?
Thank you in advance.
Leonardo
___________________________________
L'email della prossima generazione? Puoi averla con la nuova Yahoo! Mail:
http://it.docs.yahoo.com/nowyoucan.html_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
