Re: 42.0.0.jre7, driver logging takes 30-40% of my server's time

I am using logback and I don't see any postgres-driver related logging,
so I assume it should be off

Looking at the stacktrace of the profile though, it seems it passes this
code:

if (!isLoggable(level)) {
return; }

So it seems as if it is ON though it doesn't log anything.

On 22/03/17 17:21, Jorge Solórzano wrote:
> Have you enabled the Logger with a FINEST (TRACE) level?
>
>
>
> On Wed, Mar 22, 2017 at 11:13 AM, Konstantinos Kougios
> <kostas(dot)kougios(at)googlemail(dot)com <mailto:kostas(dot)kougios(at)googlemail(dot)com>>
> wrote:
>
> I tried to paste an image with a profile, but my email was rejected.
>
> It seems logging is called in places like row.getInt(),
> row.getString() etc without a check for the logging level. Then it
> takes a lot of time for those to be processed, especially for
> queries that get a lot of data. It goes down to parsing strings
> and locale and it just is slow. I see postgres processing a query
> for 1 sec but on the java side it takes 5 secs to get the data
> back to my code. Part of this slowdown is due to the logging. Can
> it be optimized, i.e. having a boolean to true/false if logging is
> enabled and then do the calls?
>
> Thanks
>
>
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org
> <mailto:pgsql-jdbc(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
> <http://www.postgresql.org/mailpref/pgsql-jdbc>
>
>