| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102 |
| Date: | 2016-01-12 09:03:41 |
| Message-ID: | n72fhe$cf8$1@ger.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-jdbc |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dilip Kumar | 2016-01-12 09:11:47 | Re: Relation extension scalability |
| Previous Message | Etsuro Fujita | 2016-01-12 09:00:02 | Re: Minor code improvements to create_foreignscan_plan/ExecInitForeignScan |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vladimir Sitnikov | 2016-01-12 10:44:07 | Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102 |
| Previous Message | Edson Richter | 2016-01-11 22:44:34 | Re: Driver behaves differently with prepareThreshold and timestamp fields when daylights is active (was Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102) |