Re: Odbc through vpn

On 20/03/2015 15:07, Adrian Klaver wrote:
> On 03/19/2015 03:01 AM, Enrico wrote:
>> Hi, I did a migration from postgresql 8.1 to 9.4.1 and I have this
>> problem, only for clients who work through the vpn, queries are very
>> slow and this problem did not exist before migration,the network is
>> the same , the server is the same, the current version of postgresql
>> is 9.4.1 and odbc is the latest 32-bit version.
>> For the clients who work in LAN , ODBC works fine.
>
>>
>> Can anyone help me?
>
> To be clear and get more information:
>
> 1) What OSes are you using for clients, server?
Client windows 7

server debian 7.8.0

>
> 2) You upgraded from Postgres 8.1 --> 9.4.

Yes

>
> 3) You say you are using latest 32 bit version of ODBC, so was that
> upgraded at the same time?
Yes

>
> 4) What is the exact version of the ODBC driver you are using?

9.03.0400
>
> 5) What happens if you run the queries remotely without going through
> ODBC?

For example:
I have a table with 5000 records,

if i I write select * from table limit 100, the response time is ok
about 1 sec,
If I write select * from table limit 500 the response time grows to 6-7
minutes

>
> Wonder if it is related to this thread about SSL compression?:
>
> http://www.postgresql.org/message-id/CAKwe89Cj7KQ3BZDoUXLF5KBZ8X6icKXHi2Y1mDzTut3PNrH2VA@mail.gmail.com
>
>
>
The connection is not ssl inside vpn.

Regards,
Enrico

--
That's one small step for man; one giant leap for mankind

Enrico Pirozzi
Tel. +39 0861 1855771 - Mob.+39 328 4164437 - Fax +39 0861 1850310
http://www.pgtraining.com <http://www.pgtraining.com-> -
info(at)pgtraining(dot)com
www.enricopirozzi.info - info(at)enricopirozzi(dot)info
PEC: enrico(dot)pirozzi(at)pec(dot)it
Skype sscotty71 - Gtalk sscotty71(at)gmail(dot)com