Unix Technical Forum

Optimizations in the latest driver

This is a discussion on Optimizations in the latest driver within the pgsql Interfaces jdbc forums, part of the PostgreSQL category; --> Hello, I'm currently using jdbc driver version 8.2dev-503 (jdbc3), and I'm working on an application that performs massive insertions. ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces jdbc

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-16-2008, 12:15 AM
Julien Patrouix
 
Posts: n/a
Default Optimizations in the latest driver

Hello,

I'm currently using jdbc driver version 8.2dev-503 (jdbc3), and I'm
working on an application that performs massive insertions.
While profiling it, I noticed some overload in the driver. I made some
quite straightforward modifications that removed those overloads.

I would be happy to contribute to the improvement of the driver, and
would like to know what is the best way to do so.

Thanks in advance.

Julien Patrouix.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-16-2008, 12:15 AM
Dave Cramer
 
Posts: n/a
Default Re: Optimizations in the latest driver

Julien,

Send a context diff of your changes.. to the list.

cvs -c diff

Dave
On 28-Aug-06, at 3:35 AM, Julien Patrouix wrote:

> Hello,
>
> I'm currently using jdbc driver version 8.2dev-503 (jdbc3), and I'm
> working on an application that performs massive insertions.
> While profiling it, I noticed some overload in the driver. I made
> some quite straightforward modifications that removed those overloads.
>
> I would be happy to contribute to the improvement of the driver,
> and would like to know what is the best way to do so.
>
> Thanks in advance.
>
> Julien Patrouix.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-16-2008, 12:19 AM
Simon Riggs
 
Posts: n/a
Default Re: Optimizations in the latest driver

On Mon, 2006-08-28 at 09:35 +0200, Julien Patrouix wrote:

> I'm currently using jdbc driver version 8.2dev-503 (jdbc3), and I'm
> working on an application that performs massive insertions.
> While profiling it, I noticed some overload in the driver. I made some
> quite straightforward modifications that removed those overloads.
>
> I would be happy to contribute to the improvement of the driver, and
> would like to know what is the best way to do so.


I didn't see any further comments on this.

Are you still willing to share your work?

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-16-2008, 12:19 AM
Julien Patrouix
 
Posts: n/a
Default Re: Optimizations in the latest driver

Simon Riggs wrote:

>On Mon, 2006-08-28 at 09:35 +0200, Julien Patrouix wrote:
>
>
>
>>I'm currently using jdbc driver version 8.2dev-503 (jdbc3), and I'm
>>working on an application that performs massive insertions.
>>While profiling it, I noticed some overload in the driver. I made some
>>quite straightforward modifications that removed those overloads.
>>
>>I would be happy to contribute to the improvement of the driver, and
>>would like to know what is the best way to do so.
>>
>>

>
>I didn't see any further comments on this.
>
>

Me neither.

>Are you still willing to share your work?
>
>
>

Yes of course. Maybe I did not understood well the procedure, if any ?

--

Julien Patrouix

Genoscope
(+33) 0 1 60 87 25 94
mailto:jpatroui@genoscope.cns.fr






Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-16-2008, 12:19 AM
Simon Riggs
 
Posts: n/a
Default Re: Optimizations in the latest driver

On Fri, 2006-09-29 at 13:27 +0200, Julien Patrouix wrote:

> > Are you still willing to share your work?
> >
> >

> Yes of course. Maybe I did not understood well the procedure, if any ?


Please post your changes as a patch to this list as a diff -c patch that
applies cleanly to the driver source.

For each specific change some accompanying docs are likely to be
required as well as the test cases and test results that show your
performance improvements have been successful.

Sounds like we need a few words on the FAQ to explain this? Please give
all the feedback you can so we can encourage others also.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:30 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com