[Pgpool-general] Partition pruning

[Scara Maccai]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20080228/8e7bf129/attachment.html