Re: PostgreSQL over internet

>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.