Re: 500 times slower - Mailing list pgsql-odbc

From Karol Szkudlarek
Subject Re: 500 times slower
Date
Msg-id 4209F88A.8060200@mikronika.com.pl
Whole thread Raw
In response to Re: 500 times slower  (Karol Szkudlarek <karol@mikronika.com.pl>)
List pgsql-odbc
Karol Szkudlarek wrote:
>
> The problem exists only between windows client and remote windows
> server. The other configurations (for example remote linux server)
> works ok. We are using stable version of psqlodbc driver.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

Hi!

My collegue spent some time to dig the following case and it looks like
Nagle algorithm and delayed ACKs related problem.
In psqlodbc.h
#define SOCK_BUFFER_SIZE            4096

I changed that value to 8192 and driver works fine for me.
I am not sure why this change helps.

Karol

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: queries run twice unless 'parse statements' checked?
Next
From: "Dave Page"
Date:
Subject: Re: 500 times slower