[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] PostgreSQL over internet
From:       belal hamed <belalhamed () gmail ! com>
Date:       2013-01-28 11:15:10
Message-ID: CAHsqH1zpVdF0reVjtxg8uZOUfvYy876gXg8n+Z2k1TXaN_ekXw () mail ! gmail ! com
[Download RAW message or body]

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

[Attachment #3 (text/html)]

<div dir="ltr">&gt;Due to the asymmetric communication, a bigger data output in a \
single<br> &gt;packet (the result of using compression on the tunnel) will get \
sent<br> &gt;without waiting. A smaller packet will delay a bit waiting for some<br>
&gt;additional data, which in your case does not come. You may want to<br>
&gt;check out this document describing some of what I believe is causing<br>
&gt;your observed behavior:<br><br>Slow<br><br><img \
src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAgoAAABNCAIAAABIYdv/AAAT20lEQVR4nO2 \
dT2zbWH7HmUNm4s1g0cHOouihaDE7ZxcB3MJAT0VRbG9bQJctxkVRDfawQOdobA9FQYoURdG0ZckSbPmfkihK5 \
FauIm2czHrUaeSJrZ3NCMJ4dIl8sS6VL8HoYvCoHihR/CfqkZL4+JzfB7+DIVPke78nvu/783vvUT0A8CXdbvf \
58+eJRCKRSGQymVarhTtFAPBuQeFOAAAYqVQqHMfRNLOyurafP9zPH26k91iOe/zkCe6k6bi6uspms/FEIiIIu \
/uZUqkkyzLuRAHA1AB5AHxEs9mMCEJ0RXr2qt7oXGvtdfvtWiL5MJvFncY+D7PZUCi0sbWznz8sHJ9spPdWYnG \
aZtbjiaurK9ypA4ApAPIA+IWd3V2W4wrHJwZh0CoEHxHq9TrulPay2Ww8tfm6/dacwv38YYhlD4tPcacRACYF5 \
AHAjyzLa7HY5t6DUcKg2rNXdZ7n8Y7hVKtVISraJPL0orMSi8fWEzDWBBANyAOAmW63GxGEbKE8VhsUi6c2nzz \
JY0wwz/NPv6qNTed+/lBckUAhAHKhuHCY9j0cF8btqF6v1wNfTR1ZlsNota1q1eZlKBTCVe02m02W4xCTenBUA \
YUAyIWiaRr9zcRlNE3jdlSv1+uBr6aLLMsrknRwVHGax/XkZj6PpwMhSauPSy/QkwoKAZALyIMDwFfTJZ5I3M8 \
fusgjrg5Es9nkkLsOqj0slFfXYh4nFQAmB+TBAeCrKfIwm93Y2nGdzVgiWSgUvExwu93mef7IFHGLYvv5w/V4w \
svUAsDkgDw4AHw1LWq1Gh8RJsnms1d1juO8Sa0sy/l8Pszzv/vD964TvJHe29nb9ybBADAVQB4cAL6aCldXVxz \
HVZuXE+Z0ZXXt+fPnM02nsqtHKBSKpzYnT/BGeg/6EABBgDw4AHw1ObIsR0XRZu0bup1edDiOa7fb00rb1dVVt \
VrNZDKiKDIMwzD9XT0mFwbV9vOHq2sxmKkGiADkwQHgq8nZ3EpvP8hNK7Ol/63xPN/tdidJkizLpVJJEASGYYS \
omNreOziqTFESDPawUBZXpAnT7EMg7PvmQdFQ5SEDvpqQL7+sRFek6eb3v7884Xne9X6ulUolFAqtrsen0qFBt \
IOjSohlX76sTte9eIG3Ax1SpJSioVCRAV9NQqvVCvP86UVn6ln+3R++D/P87u6uo73wut2uKIrRFWl2HQUbqzY \
vI1ExKorV6g0RCXg70CHFVyAPDgBfuabb7YZ5/otv3Ef+2NvpRWdr7wHDMIlEotls2idGGU1iWfY/n/8P3sI6O \
KpEomIoFNraSlcqFaJHnODtQIcUX1nIQ5lZpCiKoqh55rzMBJfPrhudYoBa1P/hws6XFygdS0XbhxJeqLkgRQW \
To/JOUfPMuXpxcqn/SZIRy7rrHXvbJ74yIEmSo8XGru1+/pDjOJ7nU6lUNput1Wpql6LVapVKpVQqxTDM6nocS \
6fB0iqNN1v3H0VXJJpmaJqOCEJEEJRDkCqVCinz2KRUebj91OuR4yujPCSXKGpBqaGUKntx+UypvNyogrmiTy5 \
Rgdx1o3PdOBPnB1Wk5UNJL9TkUjCgZtaQ944iHgOBzAWV7JeZRdUPjc758oIbn/vEV1p2dndRdmOdoj39qrb76 \
CC5tcNHBIZhlLFUlmXX1uN7uYNZDHBN0QrHJ4XjE+UQpOiKxDDM1lba/x0LUqo83H7q9cjxlV4ezsR5Q9WcCwZ \
y166rquSS8VvaKjK5RFFLxdEPJbpQi4GlYiMX1PaQknq1aOSCfSHUXDboPbj3uU98pbKfyaS297D/1sm104tO+ \
v4jlmV9PktBSpWH20+9nslXpsGDYsA41hBMmkYgBsMPppEGpem5sDhvcZNr80iGdhjD4CudPOhbr1pTqyrd4JK \
Sq8FXigEqmOynTCyrqaRGtaCLgf5Q0qiHeleo9+7d+/rrr50Wqp2dicu5gU8s8q56VSmbYkA/1Kb3OZEvgMLDb \
HZ1PY69UrgBpkxlP33q31OGQB7Q0fkKYfCgzIhqzd6vQ3JBTdVaDBirWeW7ljexuY/RV87kQTfKlAuqQ0PzTLG \
vSEtFVULKZ0VzBddXFM3cgx/kgaKo9+7M/fO/fOagUG1NLQlDb2mEPFwP2gtad/lUHhCltNVq8TyfnGBXJTCzr \
a7HfasQIA/oGOUBdfBAU63rao/rMrOo6QScLzPF0Texu4/BV057D8PnqZPJGlVQOy8W2tXPv7GK9Is88L+9/OM \
//eTPP/7k8vISqVDtTN99U8veTh5Ul6oe86k8IEopwzDll7/3+OV/F2zWW4m4BuQBHb2vxgweWLb6jXO0Z+K8O \
lDRH7oYdRPb++h9NW7uof8ka3nQV3Yu5WH0Q70rVIqi0t/20t/2/voXn83d/WB7ewehUEebLv1DJ9jMPVj1MPw \
rDyhSKori4QvMYaM30k4vOizLOlrh4Q0gD+iYfGU5eGCYM9B/aGxSa2t80SpgMmiQhxH30fnKLnKp0SkGFtQ4S \
1ONP+wTFQMT9B5GP3Rot2/fNs6yTJVbt24p8pD+tvd5/GjuRx/87d/9HKFQrU0v1MN+nzlyqd91GAw+mjp92nH \
DRcvxQe9fAEQplWVZklYLuBcW3EjLFsprMd8dIAFh3+hY+mrU4IFF70Ef8zJ06YJY7hSXtaNM9r0Hy/tofGWx7 \
kEzPdAvv/440oKYHPxR1l0ZTKp/LxXLmmuUD7WDXOayH/VQralVkmf2s/nFu3c/+O6778YWqt4GeVQV7kw0xQ/ \
00UiFuJwbXLZUNPjKxi2W5hMp7Q0U4r9AIWZgkajvlltD2Dc6hrkH5MGDYfPRqp1dDFCLy4yIMH9pf5+hr8hYN \
U15Lg/pb3v/9O87t2+/95vf/Jt1ofrVvPeVpZQqyLIsSRL2xck3z/AeuG0JhH0roMRuWEYu2QweNM7EAHOuv0A \
XFamYaR7X8ibXY++j+grkwc74315++NM/+fhnn/zwww8OX4B3y1dmKVVxfaA0mL35bY4awr4VKITYDb08mAcPz \
OseFpfPhiMK2phU3bjCUABG3eRaOzIx8j4DX4E8jLe/+vt/vHNnztkL8O75yiClWmRZZhjG52uVibP9/GEi4en \
hQvbtYgj7VqAQYjeIqElAHsbbryL59+/M/evnn5NSqD6RUgOSJOU82XPp3bFq85JhmNlWdXrs28UQ9q16SXkXb \
GI3iKhJQB7G2L2/+Ycf3f3g6OiIoEL1iZQayOfz68lN7M65YRYO8/V6fba1nQb7djEpYd9zc3OuYjJQQYndIKI \
mMcuD3aaq6iYZFBVM6sKnZrfJa9+8r/L+I//djz/8aP4v7mmHSkYX6sBvVlFi+q1HLL87qX/w+spSSg1sbaW37 \
j/C/ou/YZbc3stkMlOVADvs28WkhH17/4KYYzcIlYdrXTlpNlUtM4uauQvdZNGsN3ltdK5v3bo1U8F/786ctjh \
/8Wv2/TtzIZY1vB72hWq9/lDjQ0tz7ahR5hMpNcCy7OwOe3hnLVd6IUmS6mS87WIiwr6xyEPaFLsxgTy4PxbBq \
Y2TB3VTVdOWT4OlcF5s8trwcKlX7OUPH88vfviTjyzDNMfJg7jMLBo6EMqHNvIw9d6DT6RUS6FQWEsk0bOg3a9 \
lGLtiehmsYjOMGL+uZcGwxsr8L9NTHD1d12YalbaJyvrZqzrHceafMZZ2MTEtYh/EbkzoK3fHIrjxla089DdV1 \
S9x1JmjTV5NwyxIm7w2vJKHz+NHd3/8R6MWeY19AcqMmDQGERcDS0Wl+6wV9v5/h4N1I/xzJs5rlyJqHWVbqB7 \
4aqyUqjSbzTDPv26/dfbrNDc7BvW4ec+uQE4zvKD94mDXSKsf6vnywrCkdP+19rPd0+3vPzZtru30okPTjLlos \
LSLQR5QTIndmJo8ODkWwY2vbFdNW2+qOmwNKWukETd51e3weq4fr7fb5LXhSZVnv0WEAoI86LZOVPp3ZWZxfik \
4r3jpTJxXqhh1Cy21XEf4Rx/6Pb6r4RMpVWg2m3xEcBPSaikPS8HAAmVoFg3kQUxafFHdunLMzo+G/yaXKFN7y \
O7p9vcfm7bJ3mFGPSkIb7v4Jx/99Os3/zd5jmZqeOVBjd2Ynjw4OBbBja/sB5ca/d/3ovFtORPnLVa6a82485J \
ph9drxG2aGp5UeX9mu8GcAoo86DLFDMRV02lQan+Nijj1z8hF8J75CkVKe71eu90O87zLMzut5UEs94d0dA1/n \
UMsvjj4DWsFgNH9aE0bNljKg93T7e9vn7ZJLBQKtdtttWgwtov/8ue/fP/O3BSzNgvDKA/a2I3J5cG+BT81X6H \
Ig8X86kAe0Dd5tYou8Is8oBxgMLZQtYt9lBE5zZa5w2FrdazJLA9o/sEvDyhS2m63IxGh0njj8tc5Uh4G85kaf \
zqXB+O2j9r/GuQc8en297dP2yTmE3n4VSR/+733f/nZr6eYtVkYFnkwx25McXDJ6uc9PV8hycPgnRl+rsoD+ia \
vxh1er/0jD4ggyoNSC8wvDaub+aXgoF7QeEN3tl8wieofzPKAKKURQSgcn7j/ddrIg74GdyAPWszyMOJfiE+3v \
7992iYxP8iD0i7+9NNPRyTSR2HfNE37IXZj6vKAciyCC1+NXPdgMW82nEqlDCOwiJu8and4HX7LbpPXYUKnX88 \
5Z/y6B80k8yB8y/jr0c0p6T8c5R/1FTLsmDuqUHH7qVcqlaTYZGeI2spDQ/M7mW7vwWIcFe3puHoP2uKmsLaLi \
Qj79nLVtE3sxvTlAeFYBBe+ImPVtB+qvB45oXu4/dRLJBL7+cOJMjJOHtRe1/KU5x7Olxcs27ljno5l7sEQ2Iq \
3XUxE2Ldn8mAfuzGVdQ9Oj0Vw4SuQBweArxCZdGSpgyIPw0VVLuSh0bluaFb+6/6rRpd1HDzd/v72aXNtG1s72 \
WzWs2K1bxdD2LfqpbGxG6TUJCAPDgBfITKb3oNVfzkXdCsPulkcw5iScaYN4en297dPmzvz/lRR+3YxhH2rXho \
bu0FKTQLy4ADwFSL1ej0c5l1nwbRqWvfJqIVpll9sdK5HL2/WhgYYbq6bTBr3dPv726fNpZ1edPiIUKvVvCxW+ \
3YxhH0roMRukFKTgDw4AHyFTjyRyEzYgQCzstfttw8LZZZlvT8LyL5dDGHf6JBSk4A8OAB8hU6322VZ1uWaODC \
9VZuXudKLxOZ2OMzTNL0Wi3k5pqRi3y6GsG90SKlJQB4cAL5yRK1W4yMCdocQaqcXnf38YXRFCoVCDMNIkpTNZ \
r083cEpEPaNjsZXbs5QULI8z5xbB8hNyUAenAG+ckoqldp9dIDdJwSZqgo0zSQSiUqloq568znwdqBj8JWzMxQ \
GB2DMYqW0wVcgDw4AXzlFluUwzz97VcfuFp9btXm5++hAqwq4i84x8HagM1IeUM5QGI6zjVheMz1fgTw4AHzlg \
m63GxEEUAizvW6/LRyfbKT3wmGeYZhUKkWiKqjA24HOaHkYf4aC4TQ29Q76gbVigAouG8O9hntN6q9XL9aFBYM \
8OAN85Y6rq6swz7vfno8c++Kb7wvHJzaWK73YSO+pk8wRQchkMn6eUUAH3g50zPJgmHuwOUOh0bkexGobzw6xW \
hRy3dCuRsyJpkUkRf3FOl+BPDgAfOWaSTdw9Z9Vm5f7+cPE5jYfEegBLMtGBMHGJEnKZDI+n2R2B7wd6NgMLil \
mc4aC/pqxi0L69+/rAaNuLKa93rCafegrimYYmgCY8S6fPeCrSWi1WjdjHuJhoRyJigzDJBKJbDZbq9VkWcbtX \
fzQIA/I0OPkwe4MBc0xcMoXbReFqHcLJgd7uJquHy0PuB0FvEMoBwQ9Lr3AXk24s9OLTiQqrsVi1WoVty99B8g \
DOuPlweYMhUHk0nCdh92ikOEjdMfl6q4HeQD8gSzLkiRtP8hhrymc2rNXdZZlQRhGAfKADm217gH1DIWcuJzrb \
wc5DGGyXBSiHYw6EwOa+2uvH3XkBsgDgIfNrfRqLO7mDGpMVmm8CfM8KUsQsADygA4pvgJ5APDw9GmJlKmI1+2 \
3YZ5vNpu4feZrSKnycPup1yPHVyAPADaUyWr/DzRFouLLlzCmNAZSqjzcfur1yPEVyAOAE1mWN7fSkaj49Ksa9 \
vfB0uKpzcdPnuD2EwGQUuXh9lOvR46vQB4A/FSrVZ7nQyzLRwQpFt9I72mtcHyCa+fXwvFJRBBwu4cMIOwbHRr \
kAQAc0Wq1arVaqVTK6IkIQigUWk9uvm6/9fL1eN1+y3Jcq9XC7RjgpkGKlII8AAQgy/KTJ/lIVPRSHlLbe/uZD \
O6sAwA2QB4AYvBye/Avvvme4zhYDg28y4A8AMRQKpWkWNwbeYiuSETvnwoAkwPyABCDZ8fPPXtV5zgOd3YBADM \
gDwAxeCYPLMfBIjgAAHkAiMEbeciVXkiShDuvAIAfkAeAGOr1ejjMz1QbYP8MAFABeQCIQZZlesbriTb3Huzu7 \
uLOKAD4ApAHgCQ4jpvdLn6VxhuWZSGYFQAUQB4AkshmsxtbOzOSh0hUhOMcAEAF5AEgiaurq1AoNIvdNXZzB8l \
UCnf+AMBHgDwAhLG1lU7ffzRdbXgM0UoAYALkASAMWZZZlq003kxFGE4vOmuJZFQUYcoBAAyAPADk0W63IxFhw \
jnqXOnFWiIZCoUKhQLuDAGAHwF5AIik3W5zHLeWSGrPEXrdfls4PnlYKKtnRURXJD4iGCwUCtE0LUlSoVDodru \
4swIAPgXkASCYQqHA8zxN0yzHKVvURwQhFoupZ0VUKpWaiXa7jTvhAEAA/w8qgD/RnJ7mdgAAAABJRU5ErkJggg==" \
alt=""><br> <br>Fast<br><img \
src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAs8AAABNCAIAAADW9x4aAAAXDklEQVR4nO2 \
dT2zbWH7HmUNm4p3BooOdRdFD0WJ2zi4GSFsDPRVFsb1tAV+2GBdFPdjDAp2jsXMoClKkKImmLUuWYCuxrSSKJ \
nIrV5E2TmYz6jTyxNbOJoIwji6RL9al0iUYXQwe1QMl6vGvniiKj2R+H/wOhi2Tj9/3xPfl4++9Rw0AAPAt/X7 \
/8ePHyWQymUxms9l2u026RAAAAAZQpAsAAIAdqtUqx3E0zaxvbB4Ujg4KR9uZfZbjvnzwgHTRVPR6vVwul0gmI \
9Ho3kG2XC5LkkS6UAAAuA24DQDwGa1WKxKNxtbFR88bze4VGi86bzaTqXu5HOkyDrmXy4VCoe3d2weFo+LTk+3 \
M/no8QdPMViLZ6/VIlw4AAPcAtwEAfuL23h7LccWnJxqfgRoOPhJtNBqkSzrI5XKJ9M6Lzht9CQ8KRyGWPSo9J \
F1GAABcAtwGAPgDSZI24/Gd/btmPkOJR88bPM+TfWFRq9WiMcGikKcX3fV4Ir6VhBcrAPA2AG4DAHxAv9+PRKO \
5YmWi1ZAjkd558KBAsMA8zz/8pj6xnAeFI2FdBMMBAIGH4sJh2vNwXJisTKASPqCV40iSFMbrvJWotS5DoRCpX \
rzVarEch1nUw+MqGA4ACDwUTdP4tzBSQdM0WZlAJXxAK2eRJGldFA+Pq9Ne41Zqp1AgM7whihtflp/gFxUMBwA \
EHnAbWIBK+IBWzpJIJu8UjmxcI6nhjVarxWEPbChxr1jZ2Iy7XFQAAFwD3AYWoBI+oJWD3Mvltndv277MeDJVL \
BbdLHCn0+F5/lg3NRcnDgpHW4mkm6UFAMA1wG1gASrhA1o5Rb1e5yPRWS7z0fMGx3HulFaSpEKhEOb53/3hle0 \
Cb2f2b+8fuFNgAADcBNwGFqASPqCVI/R6PY7jaq3LGa90fWPz8ePHcy2nvHR6KBRKpHdmL/B2Zh9GOAAgeIDbw \
AJUwge0mh1JkmKCYLGEF36cXnQ5jut0Ok6Vrdfr1Wq1bDYrCALDMAwzXDp9dp+hxEHhaGMzDkmjABAkwG1gASr \
hA1rNzs5u5tbdvFMXW/7fOs/z/X5/liJJklQul6PRKMMw0ZiQvrV/eFx10GFo4l6xIqyLM5bZg8D8cOCthaKhb \
8AAVMIHtJqRr7+uxtZFZ6/3v78+4Xne9g6x1Wo1FAptbCUcGW7BjMPjaohlnz2rOSsvWeDbgQ84s4AJRdHQ+jE \
AlfABrWah3W6Hef70ouv4Jf/uD6/CPL+3tzfVdmj9fl8QhNi6OL9hDIuotS4jMSEmCLVaQDwHfDvwAa0CJhS4j \
UBVJ1mVZEAr2/T7/TDPf/Wd/Tkd1nF60d3dv8swTDKZbLVa1oWRX52wLPufj/+HbGUdHlcjMSEUCu3uZqrVqq9 \
fr8C3Ax/QKmBCGbiNCrNEURRFUYvMeYVZXTu7anZLy9SS+gcbcb52k1KxUrI8qYdqFFUptUKNilrCuSKURebci \
ZozrgXiKslM1/TzqxS1mjJrIWrFZOUXmfMUI1RUn5+6TXpEKw2iKE61BKftuFM44jiO5/l0Op3L5er1ujLg0W6 \
3y+VyOp1mGGZjK0FkSMMwqs3Xu3fux9ZFmmZomo5Eo5FoNJlMZrPZarXql5RSv3QMpHUaDECrwAmldRupFYq6K \
d/K5f5yae1MvsvbMRl635BaoZbzV83uVfNMWBz1JYYn9VSNalSqMEtKL2h4Rei1jz+cX3XEbZhVB3GVZKZq+qm \
V1WVFQI2eXdmLjDxcflVuJBVmSWktze752k07LdMjWqHc3tvD2d/VwXj4TX3v/mFq9zYfiTIMI79eZVl2cyuxn \
z+cx9scB6P49KT49OSgcLSd2Y+tiwzD7O5mvD/s4ZeOgbROgwFoFTih1G7jTFjUdGP51eX8le17empF+19oX5J \
aoaiVkvlJPVSjWG5DuSK1COiHHQrj6iCuksw0Tb+0vFJq5ldR0VJq89HMrw6tFfKx0diG/ZbpEa0UDrLZ9K19R \
xvJ2xWnF93Mnfssy3o8w8MvHQNpnQYD0MquULox4NKydsh4NaUbSB51UroBY/mR7+bSosFBrvQD0madndZtqJ8 \
a0VDu6aox/OE7hZvKJa2mhiUTKkopKbMn19Ly8L2J2Undq9FPPvnk22+/xa9OE7cxvCJN4ZEPy7W+mlKNT+h0M \
/iNRmoybmOiSoZaWcWZsJYfXa9BC1HanqxqaZnSm7kguI17udzGVsK1+2OAQ84qffjwIekqNQV6UHxAKztCYYw \
BVxhBMQrDm21+FempS8vaXlv+X8ODWBxHK9R0bkM1hj96L5BaQTIYVkqKI6mclfQ9gZL0oIyQe8FtUBT1zo2Ff \
/nXz7CqU+c2NFekCfXYhtKzypKe63TT/0Yj9TkptzFRJUOtLEJpr5rxIRO3cTWya+i1e9RtYDqzdrvN83xqhp1 \
QIPSxsZXwrOGAHhQf0MqOUFOMASMuQXWb1fRZ52tMyfwgVsfRCDXt2Mb4fKosyGHXiPajxoXT9SVecRv8by//+ \
E8//vOPPr68vJxQneZvUgzD0m1g/UYnNTG3Ya2SoVbmoR6CU74hVm5DaXjK5XvUbWA6M4ZhKs9+P23hISbGvNd \
rtw30oPiAVraEmjAGbDgmoU2XPBMWlfHm4Qi02UEsj6MWalLexvBMxm5D3SvYdBvmJ3WvRimKyrwcZF4O/uYXn \
y289/6tW7ctq5OA29B1wGTchrVKhlqZhqqWx1dkkbdhNP7hXbeB48wEQTh6Qnh+aSDj9KLLsuxUK4u4A/Sg+IB \
WdoUyHAPW5Fuof6l94EcNhGA0Z3BV4zZMjqMSympOSrNbWtYmCiA39/GITWl5hrEN85OO4/r169Q8uXbtmtyPZ \
l4OPk8cL/zo/b/7+59bVKcTbkPJ4cDwH1qpjbtY4iqZNH0zWVB3PFZJPydFmdGDpK0Yuw2dLSN2j6DwnJkkSaK \
4USS9oEUgI1esbMbjc61lG8D8cHzAbcwilNkYsMHYhjpPf9z2bgqVbmkNfaViPbZheBxEKIP1NpBEhGFDH47k3 \
xRSox9UqYvjtEeKWilVkM/Iv0Tf6Oi/JGYnRUO5d7sWP1tceu+997///nt9dRqut2GSiIvcIJA3BfItYHGcCqP \
Sbc1cSVmciroWvKOSRdM3lkW5hDNBl/A8BHEewlp+9LGVklZe88ZjGB5xZoOR4fgvMBxziEjMc4uQwvxwfGCVI \
xtCTTMGPH5sM3pmLi1TS2uMgJEkZ32csVAGbsODQbnej2ZeDv75329fv/7Ob37zhbY6vRrEVTJo+l4N97UydGY \
ykiSJokh8yc7gRa11GQqFPLXwF8wPl8FJo4ZVjuwIhTEG3DwTloezDdB5KNpHNV1KpeFBriYeRxEK3IZV8L+9/ \
OCnf/LRzz7+4osviIvgfZV++OEH/T3Cm+ERZ6YgSdK6KB4eV4krE7DwWroozA+XoTDSqGGVIztCGYwB69fbQCY \
/KuPHwxUrEK8w9hNmB7lCB5hNjzMSCtzG5Pirf/in69ffIS6C91W6cWNBf4/wZnjEmaFIksQwjMdX8PRdHBSOk \
snkHHsDHdYPozA/XIbCSKOGVY7sCeXNALcxOX4VKbx7Y+Gvl5aIi+B9lf7t88/90vQ94sw0iKKYd2WflLcnaq1 \
LhmHm2h9osH4Yhfnhikryd8EijRpWObInlDcD3MaE+ORv//FH771/fHwMKuGo5KOm7xFnpqFQKGyldoiLE7AIh \
/lGozHXLgHF+mHUL/PDFxYW9OmWDoKTRk183QG1ofHuTEBf3HL1bsNqm1ZlJXJ53uaa1lBTlPPbxg6Dcr1v+I/ \
C9z/+4MPFv/jERi7CvNXwrEqTmj76AKH9q3rQ0vB/ndTNfa3k0DgzDbu7md079+fRNt7mSN3az2azM3oIfCjLh \
1G/zA93/wuiT6Mm7jZwVjnyoFDeDNMZsPp03wqzhOR9qDKS5r1tbLN7de3atXlZR4qiKOqdGwtodf7i1+y7NxZ \
CLGujOl1QwyyIq4SjlfFic+rEcmNVHXVplDecmQaWZb/67pVT1wghR778RBRFRWSyT+2+mB9OxG1kdGnUvljly \
INCTRNW4wtGj832Y5LbGKf7ardpGVWAG9vGNl18NxZ/9sNHi0sf/OTD6deQUO4Lc1fDojrJqoSjVYUR1pglzfC \
G/EvLHHKHxzY84sxQisXiZjKFfwnoSO94VoLulmGUTK5F++8oNzVLRen/pDvLVGdXWXOzss1U14+eNziO0zdj1 \
wJ9GPXNY6gH0qhhlSMbQtkIw/EFw8fmWRuVpdsYpfuqlrRTxVTbxupGy7G2jW261Y9+njh+78d/NNv6mHPfRNe \
6OsmqhKNVhRGQB4tRM1gpyc8iqJse/nX8/s6kFZ0Ji+i6c+qscrJaTXRmCq1WK8zzLzpvpvsO693t6Far341oO \
Y8MDqP/iCxIYDTDflxTqr8a62x1duvjTyyb7Ti96NI0o68aN0N5GAW3gRNyGrUvtAqAUAbjC6aPzbM1Ksu1RI2 \
3aR0/hchOEHPbWIMUX+UUVtvGNl3pGxzZ+8OFTXStq5OsSjhayS+k0XFOeYyuwiwtrqwuyuqdCYtyj6VsDqS0f \
pNWpF5yYPJAiEecmUyr1eIjUTtzXw3dxsrq8k1K8ywychujbADVPyp7PE7YIlHz19QKpXsIsTq79fEnlm2WoGm \
m3++jVeN+yA+jP/nwp9++/r/Zr2iuQdZtKGnU4DbcEUo/voCzVaqdRmX9JkUOddLGVbM7fKDULZSLhna3FF2K7 \
xXm1ipNV/qGP3NiX1MXNtG1rk6yKuFoNepUkItlSooa6HtZudGPfjNtK5owIOQRZzYYDDqdTpjna61LO99hY7c \
hVJA1BpSWqRLE4B8NGjCyKqX+r7LP07sNq7NbH9+6bLNEKBTqdDpK1ZDqHjIvB3/581++e2PBwUubRxB0G2gaN \
bgNd4SaOL7gWKPCcRsGSXwjt4G/baxRRrRX3Ma0a+iaxvw30bWuTrIq4WiFrlkkv6RDtioev2dVXqzo3QZeKyL \
vNnCcWafTiUSi1eZrm99hU7cxSi1E9JzebWj3R0T/qnGHmGe3Pr512WYJj7iNX0UK199595ef/drBS5tHEHEb+ \
jRqcBvuCGU8vkDMbYxuLuPfK24Df9tYbYrvlXfcxkTszUmZxya61tVJViUZTLchdyqLK+Pea3FlddTNIG1mrAl \
FyXktWK2IsNvAdGaRaLT49MT+d9jCbagNwRRuA0XvNkz+hHl26+Nbl22W8ILbkB9GP/30U5NCemh+OE3TXkij9 \
oXbCIBQJuMLho/NMzUq0/U2DJKzxvl6lOa9LOa2sWiK7/i/rLaNHRfUqW7AHlNV59w20Z1cnWRVkpm83gaS7zm \
asKP9jqmyltS/NGtFyh1ZI7JntSqXy2I8McsX2NptNJH24+zYhsGrVbyzkxrbQKubIvow6ov54W6uJWqRRo151 \
5Wb2SJzbvxibs7hhXxz592G6WPzTEL5Yy1R4n0DqIQPaIVJMpk8KBzNdCGT3IYyJrTmcN7G+dpNw6fwCWcnkre \
hmQFL9mHUF/PDXXMb1mnUWHeS0bJm8xj894JWjgll2nKG7VbfwPSPzTMKBW4DC1AJH9AKk1lfo3Rx3MZ4bSgbb \
qPZvWoiqwar/qrMG+pOcXbr41uXzXZs797O5XKuVav1wyjMD1dUmphGjes2lEU1Ajq24YxQpAPcBi6gEj6gFSb \
zGdswGvPMr9p1G6oMGM0LFG0uF8bZrY9vXTZ7cXrRZVm21+u5Vq3WD6MwP1xRaWIaNd6dRLWwtRL6pYzWDPY9o \
VRvsbUfxmqEXsg398stF9wGFqASPqAVJo1GIxzmbV+Cbi1R1W/M1tcy/Mdm98p80U80S1dzcFUizqSzWx/fumw \
24/Siy0ei9XrdzWq1fhiF+eEyOGnU2HcSuWkh5sBoKSNkA/pRk8sLOoum+TD5O4mjQpEMcBu4gEr4gFb4JJLJ7 \
IzDGxBG8aLz5l6xwrLs48ePXa5T64dRmB+Oz1R3EjTB1nwpI0Tb0ZsX6w9PDC9o5ZdbLriNQFUnWZVkQCt8+v0 \
+y7I2l/aCUEetdZkvP0nu3AqHeZqmN+NxN1+gKFg/jML8cHww8zbQ+WuKOTNZykjRdjU1mtI54cOTwgta+eWWC \
24jUNVJViUZ0Goq6vU6H4kSF8SncXrRPSgcxdbFUCjEMIwoirlcrtFokK5VU2B+OD5TzUlRuSjTpYwQ3dAdfyw \
/bB1e0AoRympPVySneDWFZGe7M4UY3IaN6vRuEFdJBrSalnQ6vXf/kLgmPgrFZNA0k0wmq9WqsniXx4FvBz54b \
kNYyw/nPaE9q8FSRqjBOhOWkcyMCR/2vFYaoQz3dFWneCOptW5NIQa3YbM6vRnEVZIBraZFkqQwzz963iAui8e \
j1rrcu3+ImgzSVTc18O3AB7SyJ5TBnq7d0rJ++pjiNlyZQgxuw2Z1ejOIqyQDWtmg3+9HolEwHPp40XlTfHqyn \
dkPh3mGYdLptB9NhgJ8O/ABrewJpd/TFUnx0YfBFGLdAI8DU4jBbdisTm8GcZVkQCt79Hq9MM/b36HNP/HVd6+ \
KT08sIl9+sp3ZV/I9I9FoNpv1cjYGPvDtwAe0sifUxD1dx9NwxqnE44Qhy1VbrmxPIQa3YbM6vRnEVZIBrWwz6 \
5aw3ota6/KgcJTcucVHovQIlmUj0ahFiKKYzWY9nu9pD/h24ANa2RPKeE9XzdgGsq8q8pmJq7YMj29jCjFN0xT \
NMLQPYAhXJ6iEDWg1C+12Oxg5HPeKlUhMYBgmmUzmcrl6vS5JEml1yUNDD4oNaGVPKJM9XdXjDYrb0E0htly1R \
Tna1FOIaZqmSAsFAICKTqcT5vkvy0+I30ntxelFNxITNuPxWq1GWkvPAT0oPqCVPaEM93TV7jOAuA3tFGKrVVv \
Gp5h2CjG4DQDwIpIkiaJ4626e+M102nj0vMGyLPgMM6AHxQe0ml4oqz1dkfU20CwNgynExqu2zDaFGNwGAHiXn \
d3MRjxxetElfkvFjGrzdZjn/bL0BRGgB8UHtAqYUOA2AMC7PHxY9ksax4vOmzDPt1ot0pp5Gr90DKR1GgxAq8A \
JBW4DADyNnDfq/bcqkZjw7Bm8QJmAXzoG0joNBqBV4IQCtwEAXkeSpJ3dTCQmPPymTvyuYRiJ9M6XDx6Q1skH+ \
KVjIK3TYABaBU4ocBsA4A9qtRrP8yGW5SNRMZ7YzuyjUXx6Qmov2eLTk0g0SloefwDzw/GhfdKJktbJN0KB2wA \
AP9Fut+v1erlczqqJRKOhUGgrtfOi88bNm8iLzhuW49rtNmlhgKABzixgQoHbAICAIEnSgweFSExw022kb+0fZ \
LOkLx0AAK8DbgMAAoWb+9d/9d0rjuNgkVAAACYCbgMAAkW5XBbjCXfcRmxd9PWOrAAAuAa4DQAIFPV6nY9EXbA \
aj543OI4jfbkAAPgDcBsAEChccxssx8FaXgAAYAJuAwAChTtuI19+Iooi6WsFAMA3gNsAgEDRaDTCYX6uVgMWK \
QcAYFrAbQBAoJAkiZ7zaj87+3f39vZIXygAAH4C3AYABA2O4+a3kVu1+ZplWZj1CgDAVIDbAICgkcvltndvz8l \
tRGJCrQa7rwEAMB3gNgAgaPR6vVAoNI8lzPfyh6l0mvT1AQDgP8BtAEAA2d3NZO7cd9ZqfAnzUAAAsAu4DQAII \
JIksSxbbb52xGecXnQ3k6mYIEC6BgAA9gC3AQDBpNPpRCLRGdNF8+Unm8lUKBQqFoukLwgAAB8DbgMAAkun0+E \
4bjOZevhNXTEQLzpvik9P7hUr25l9OWLrIh+JaiIUCtE0LYpisVjs9/ukLwUAAH8DbgMAAk6xWOR5nqZpluNomqZpOhKNxuPx7IhqtVrX0el0SBccAIDg8P+fQeJxEtrB5gAAAABJRU5ErkJggg==" \
alt=""><br> <br>As I said before I try a small query and big one the result same \
using IP Tunnel is fast.<br><br>&gt;You would find that if you log in to your DB \
server and use libpq<br> &gt;to it over a localhost connection that the performance \
is good which<br> &gt;points to your network as the problem.<br>
<br>when I said I connect to localhost I meant I connect to IP tunnel client witch \
connect me to the remote PGServer<br><br>&gt;Are you sure there&#39;s not any QOS \
somewhere that is slowing down the packets<br> &gt;for port 5432 or whichever \
you&#39;re using for PostgreSQL?<br> &gt;Perhaps temporarily changing \
PostgreSQL&#39;s listening port to something else<br> &gt;might be a good \
test.<br><br>yes I am sure, and if there is any it must affect both test.<br><br>Best \
regards to all.<br><br></div>



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic