From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Bernd Helmle <mailings(at)oopsware(dot)de> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Configurable Send/Receive Buffer Sizes |
Date: | 2011-08-10 17:29:42 |
Message-ID: | CADK3HHJ9TCQNxoTX24KHrkkvwaGuBvhwXp3hy4i+E1XfDomEgA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Is there any objection to this patch ?
Otherwise I will look at committing it .
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Thu, Apr 21, 2011 at 10:42 AM, Bernd Helmle <mailings(at)oopsware(dot)de> wrote:
> Folks,
>
> please find attached a patch which allows to specify the size of TCP
> send/receive buffers (SO_SNDBUF/SO_RECVBUF socket options) in the JDBC
> driver.
>
> The patch adds two connection parameters to the JDBC driver:
>
> send_buffer_size: Specifes the size of the TCP write buffer used with the
> connection
>
> receive_buffer_size: Specifies the size of the TCP read buffer used with the
> connection
>
> For example:
>
> Connection conn =
> DriverManager.getConnection("jdbc:postgresql://localhost:5432/bernd?loglevel=2&send_buffer_size=262144&receive_buffer_size=1048576",
> "bernd", "");
>
> It occured to me several times now where this functionality became useful,
> especially when working on migration projects in the past, where the
> application couldn't be changed immediately when doing large batch
> processing. An interesting example is the small test program from
>
> <http://archives.postgresql.org/pgsql-jdbc/2008-10/msg00045.php>
>
> which could be make working with the appropiate buffer settings.
>
> Maybe this is worth for discussion or even to investigate it further for
> inclusion.
>
> Note that on Linux you need to adjust the kernel maximum buffer sizes in
> /proc/sys/net/core/wmem_max and /proc/sys/net/core/rmem_max to become any
> settings effective. I have reports that this isn't necessary on Windows,
> however. This certainly needs adequate documentation.
>
> I didn't invest any time on benchmarks, but maybe there's also some value in
> it performance-wise.
>
> --
> Thanks
>
> Bernd
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2011-08-10 17:37:27 | Re: Cannot create PoolableConnectionFactory (The connection attempt failed.) |
Previous Message | Alex Nordlund | 2011-08-10 16:48:34 | Re: Cannot create PoolableConnectionFactory (The connection attempt failed.) |