Re: bad performances since 9.1 version

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Christophe Canovas <cc(dot)ais40(at)wanadoo(dot)fr>
Cc: List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: bad performances since 9.1 version
Date: 2014-06-12 09:59:00
Message-ID: CADK3HHK963wZZuFyhHh1rd0um-929++sBCR9ZEWGpJbtiWWeEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Christophe,

OK, I know the feeling

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 12 June 2014 01:11, Christophe Canovas <cc(dot)ais40(at)wanadoo(dot)fr> wrote:

> Hello Dave,
>
> I am a "little" overbusy for now ; I have to set up GitHub but didn't had
> the time to do.
> I also still have tests to do, the patch works fine for our software and
> the unit testing is OK but I have to test it with other programs
> (DbVisualizer).
>
> Christophe
>
> ----- Mail original -----
> De: "Dave Cramer" <pg(at)fastcrypt(dot)com>
> À: "Christophe Canovas" <cc(dot)ais40(at)wanadoo(dot)fr>
> Cc: "List" <pgsql-jdbc(at)postgresql(dot)org>
> Envoyé: Mardi 10 Juin 2014 12:05:07
> Objet: Re: [JDBC] bad performances since 9.1 version
>
>
> Christophe,
>
>
>
>
> Can you send this patch ?
>
>
> Dave Cramer
>
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca
>
>
>
> On 26 May 2014 06:23, Christophe Canovas < cc(dot)ais40(at)wanadoo(dot)fr > wrote:
>
>
> Hello,
>
> I've faced slower performances since 9.1 driver version.
> After some investigations, I've found metadata caching has been changed,
> and I have introducted a new caching method allowing performances to be
> similar than of 9.0 driver version.
>
> The methode implements a caching object in the
> AbstractJdbc2ResultSetMetaData.
>
> Has anybody else accountered this huge slow in performances ?
> Is anybody interested in testing this caching ?
>
> Christophe
>
>
> --
> 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
>
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message amithbm 2014-06-12 10:45:10 Re: Hibernate over postgresql
Previous Message Stephen Nelson 2014-06-12 08:34:35 Re: Hibernate over postgresql