| From: | Karol Szkudlarek <karol(at)mikronika(dot)com(dot)pl> |
|---|---|
| To: | Karol Szkudlarek <karol(at)mikronika(dot)com(dot)pl> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: 500 times slower |
| Date: | 2005-02-09 11:48:26 |
| Message-ID: | 4209F88A.8060200@mikronika.com.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2005-02-09 13:17:17 | Re: 500 times slower |
| Previous Message | Dave Page | 2005-02-09 09:16:32 | Re: queries run twice unless 'parse statements' checked? |