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@pgtraining.com
www.enricopirozzi.info - info@enricopirozzi.info
PEC: enrico.pirozzi@pec.it
Skype sscotty71 - Gtalk sscotty71@gmail.com