Thread: Odbc through vpn
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, queriesare very slow and this problem did not exist before migration,the network is the same , the server is the same, thecurrent 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? Thanks in advantage. -- Enrico <sscotty71@gmail.com>
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? 2) You upgraded from Postgres 8.1 --> 9.4. 3) You say you are using latest 32 bit version of ODBC, so was that upgraded at the same time? 4) What is the exact version of the ODBC driver you are using? 5) What happens if you run the queries remotely without going through ODBC? Wonder if it is related to this thread about SSL compression?: http://www.postgresql.org/message-id/CAKwe89Cj7KQ3BZDoUXLF5KBZ8X6icKXHi2Y1mDzTut3PNrH2VA@mail.gmail.com > > Thanks in advantage. > > -- Adrian Klaver adrian.klaver@aklaver.com
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
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
On Fri, 20 Mar 2015 07:57:19 -0700 Adrian Klaver <adrian.klaver@aklaver.com> wrote: > > So what happens if you use the previous version of ODBC? I've tried with the 8.01 version that works fine with postgresql 8.1 but with postgresql 9.4.1 I had the same result. > > > 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? It's an application written on VB, it's not mine. 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 Skype sscotty71 - Gtalk sscotty71@gmail.com
On 03/20/2015 09:35 AM, Enrico wrote: > On Fri, 20 Mar 2015 07:57:19 -0700 > Adrian Klaver <adrian.klaver@aklaver.com> wrote: > >> >> So what happens if you use the previous version of ODBC? > > I've tried with the 8.01 version that works fine with postgresql 8.1 but with postgresql 9.4.1 > I had the same result. >> > >>> 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? > > It's an application written on VB, it's not mine. The fact that the ODBC driver works fine on the LAN seems to rule out the driver in and of itself being the problem. It seems to be down to some remote network interaction. Could you try running queries against the server from the vpn clients and not use ODBC to see if that if we can narrow the issue down? > > regards, > Enrico > -- Adrian Klaver adrian.klaver@aklaver.com