Re: Odbc through vpn

On 03/20/2015 07:49 AM, Enrico Pirozzi wrote:
> 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

So what happens if you use the previous version of ODBC?

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

Is the above run through ODBC or through another client, say psql?

What application are you using with ODBC to submit queries and get the
results back?

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


--
Adrian Klaver
adrian.klaver@aklaver.com