[pgpool-general: 3385] Problem with parallel query mode

[Andre Eduardo Bento Garcia]

Friends,
I am using pgpool-II  3.4, postgres 9.3 and ubuntu 14.4.
I implemented a query parallel in two nodes with the same configuration but
diferent hardware.
I run query into distribuited tables (3 milion lines each node)
The tables (l_lineitem, h_lineitem) are distribuited.
The tables (h_orders, h_supplier) are replicated.

My pgpool.conf is configured parallel_mode = on and replicate_mode = on and
load_balance = false

Of course:
I inserted on pgpool_catalog.dist_def and pgpool_catalog.replicate_def
I created a function for each rule table like
pgpool_catalog.dist_def_h_lineitem and pgpool_catalog.dist_def_l_lineitem
I specified a rule: if the value of pk for each table is less than 3000000
goes to the node 1 else goes to the node 0.

So when I run a simple query from port 9999, I get results ok.

bench_parallel=# select count(0) from l_lineitem lli, h_orders ho,
h_supplier hs where   lli.p_h_orderkey = ho.p_h_orderkey and
lli.p_h_suppkey = hs.p_h_suppkey  ;
  count
---------
 6001215
(1 registro)

bench_parallel=# select count(0) from l_lineitem lli, h_lineitem hli where
lli.p_h_lineitem = hli.p_h_lineitem  ;
count
---------
 6001215
(1 registro)


So wnen I run a little complex query I received this message :


bench_parallel=# select count(0) from h_lineitem hl,l_lineitem lli,
h_orders ho, h_supplier hs where   lli.p_h_orderkey = ho.p_h_orderkey and
lli.p_h_suppkey = hs.p_h_suppkey  and hl.p_h_lineitem =lli.p_h_lineitem;

ERROR:  pgpool2 sql restriction(notice from dblink)

DETALHE:   SELECT count(0) AS count FROM dblink('host=andre-ubuntu-01
dbname=bench_parallel port=9999 user=postgres','SELECT
pool_parallel("SELECT hl.p_h_lineitem FROM h_lineitem AS hl WHERE  ( (TRUE
AND TRUE) AND TRUE)")',false) AS hl("pool_c$0" integer),dblink('

Its seems that the table (l_lineitem) doesn't accept to relate on the more
than four. I was thinking that it was my problem, but the relationship
works individually.

I read at this mailinglist and I found this topic about restriction complex
query (
http://www.sraoss.jp/pipermail/pgpool-general/2013-November/002312.html)


So I need your help.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141226/bb65a589/attachment.html>