SEO
vBulletin Search Engine Optimization
| |||||||
![Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work](http://unixadmintalk.com/iconimages/f42/re-re-hackers-how-embarrassing-optimization-one-shot-query-doesnt-work_ltr.gif)
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-16-2008, 01:00 AM
| ||||
| ||||
 Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work Is there any patch available for this one? I'm encountering troubles with some JDBC queries and I'd like to test it before asking some help on the JDBC list. Thanks. Tom -- Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-jdbc      |
|
04-16-2008, 01:00 AM
| |||
| |||
| Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work It's pretty easy to test. prepare the query and run explain analyze on the prepared statement. Dave On 10-Apr-08, at 5:47 AM, Thomas Burdairon wrote: > Is there any patch available for this one? > > I'm encountering troubles with some JDBC queries and I'd like to > test it before asking some help on the JDBC list. > > Thanks. > Tom > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-jdbc |
|
04-16-2008, 01:00 AM
| ||||
| ||||
| Re: Re: [HACKERS] How embarrassing: optimization of a one-shot query doesn't work On 10 avr. 08, at 12:44, Dave Cramer wrote: > It's pretty easy to test. > > prepare the query > and > run explain analyze on the prepared statement. > > Dave > Thank you Dave for your answer, this helped me to find the problem. 1 - it's not a JDBC related problem (sorry for the noise) as i could reproduce it within psql 2 - Comparing query plans between the prepared and unprepared queries helped me to find a useless INNER JOIN in the query. Removing it made the query much faster and I don't have the problem anymore. 3 - The problem was coming from my query (sorry for the noise, again). Problem solved, at least for me. Thanks again Now, i'm still wondering if there could be a planner problem, because the prepared query was running 10times slower than the unprepared one. Or maybe a bad configuration on my side Just for the story here are the different plans : The prepared query : http://rafb.net/p/Tn9g6X27.html the same, unprepared : http://rafb.net/p/lutugN55.html the prepared query, fixed : http://rafb.net/p/HmHetm36.html -- Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-jdbc |
 |
« Re: Problemas with update sentence in postgres from jdbc
|
Patch to add a socketTimeout property. »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
All times are GMT. The time now is 05:26 PM.
