Partition pruning

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_______________________________________________
Pgpool-general mailing list
Pgpool-general-JL6EbXIHTPOxbKUeIHjxjQ@xxxxxxxxxxxxxxxx
http://pgfoundry.org/mailman/listinfo/pgpool-general