Re: [PERFORM] PostgreSQL over internet

2013-01-28 Thread belal hamed
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

Re: [PERFORM] PostgreSQL over internet

2013-01-27 Thread k...@rice.edu
On Sun, Jan 27, 2013 at 03:09:55PM +0300, belal hamed wrote: Here is your problem. You need to understand the performance characteristics of your communication channel. ADSL is a VERY asymmetric communications channel. Down is usually much faster than up. How it could be ADSL problem when

Re: [PERFORM] PostgreSQL over internet

2013-01-27 Thread David Rowley
From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of belal hamed Sent: 27 January 2013 13:16 To: pgsql-performance@postgresql.org Subject: [PERFORM] PostgreSQL over internet by wireshark I monitor TCP packets I found total data transmit

Re: [PERFORM] PostgreSQL over internet

2013-01-26 Thread k...@rice.edu
On Sun, Jan 27, 2013 at 03:15:45AM +0300, belal hamed wrote: I connect to my server through ADSL connection 4Mbps Here is your problem. You need to understand the performance characteristics of your communication channel. ADSL is a VERY asymmetric communications channel. Down is usually much

Re: [PERFORM] PostgreSQL over internet

2013-01-26 Thread Richard Neill
On 27/01/13 02:45, k...@rice.edu wrote: On Sun, Jan 27, 2013 at 03:15:45AM +0300, belal hamed wrote: I connect to my server through ADSL connection 4Mbps Here is your problem. You need to understand the performance characteristics of your communication channel. ADSL is a VERY asymmetric