[pgpool-general: 319] Re: Large SSL queries fail

[Tatsuo Ishii]

We were able to reproduce the problem here by creating large table (>
1GB) using pgbench then executing SELECT * FROM pgbench_accounts.
It's will be a little bit hard to fix it since I'm not an expert of
openssl library. Unless someone comes up and try to fix it, I will
tuckle the problem but might take some time.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hello everyone,
> 
> I'm using pgpool-II-3.1.2 with postgresql-9.1.1-3.1.4 in streaming
> replication mode.
> 
> Whenever I execute a trivial query with pgpool ssl=on, it works fine.
> However when I have a complex query returning lots of results, pgpool
> just hangs.
> 
> I'm logging all statements in postgres and the query is never actually
> delivered to postgres.
> 
> If I set ssl=off, then the query works as expected.
> 
> Any suggestions?
> 
> Thanks,
> Bill
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general