From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Fwd: [JDBC] Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102 |
Date: | 2016-01-12 12:00:17 |
Message-ID: | CADK3HHLn46DhtfgsnLnpvFhZHHnj3x3vohmF9V53RRtbFacK4w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
We have an interesting problem, and the reporter has been kind enough to
provide logs for which we can't explain.
I'd be interested to hear any plausible explanations for a prepared plan
suddenly going from 2ms to 60ms for the same input values ?
Dave Cramer
davec(at)postgresintl(dot)com
www.postgresintl.com
---------- Forwarded message ----------
From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Date: 12 January 2016 at 04:03
Subject: [JDBC] Re: 9.4-1207 behaves differently with server side prepared
statements compared to 9.2-1102
To: pgsql-jdbc(at)postgresql(dot)org
> Is it possible to get server logs ?
I have picked out one of the statements that suffered from this and
sanitized the logfile.
http://sql-workbench.net/pg_jdbc_94.log
The complete statement is at the top of the file and in the messages
themselves,
I have replaced each occurrence of the statement with "select ...."
The interesting thing (at least for me) is that the first few executions of
the
server side statement have pretty much the same runtime as the ones before
the prepare.
And then suddenly the runtime shoots through the rough going up from 1ms to
40ms or even 60ms
Regards
Thomas
--
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 | Marko Tiikkaja | 2016-01-12 12:15:23 | Re: Fwd: [JDBC] Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102 |
Previous Message | Michal Novotny | 2016-01-12 11:55:43 | Re: Question about DROP TABLE |
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Tiikkaja | 2016-01-12 12:15:23 | Re: Fwd: [JDBC] Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102 |
Previous Message | Vladimir Sitnikov | 2016-01-12 11:52:12 | Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102 |