>Due to the asymmetric communication, a bigger data output in a single
>packet (the result of using compression on the tunnel) will get sent
>without waiting. A smaller packet will delay a bit waiting for some
>additional data, which in your case does not come. You may want to
>check out this document describing some of what I believe is causing
>your observed behavior:
Slow
![]()
Fast
![]()
As I said before I try a small query and big one the result same using IP Tunnel is fast.
>You would find that if you log in to your DB server and use libpq
>to it over a localhost connection that the performance is good which
>points to your network as the problem.
when I said I connect to localhost I meant I connect to IP tunnel client witch connect me to the remote PGServer
>Are you sure there's not any QOS somewhere that is slowing down the packets
>for port 5432 or whichever you're using for PostgreSQL?
>Perhaps temporarily changing PostgreSQL's listening port to something else
>might be a good test.
yes I am sure, and if there is any it must affect both test.
Best regards to all.
>packet (the result of using compression on the tunnel) will get sent
>without waiting. A smaller packet will delay a bit waiting for some
>additional data, which in your case does not come. You may want to
>check out this document describing some of what I believe is causing
>your observed behavior:
Slow
Fast
As I said before I try a small query and big one the result same using IP Tunnel is fast.
>You would find that if you log in to your DB server and use libpq
>to it over a localhost connection that the performance is good which
>points to your network as the problem.
when I said I connect to localhost I meant I connect to IP tunnel client witch connect me to the remote PGServer
>Are you sure there's not any QOS somewhere that is slowing down the packets
>for port 5432 or whichever you're using for PostgreSQL?
>Perhaps temporarily changing PostgreSQL's listening port to something else
>might be a good test.
yes I am sure, and if there is any it must affect both test.
Best regards to all.
