From: | Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com> |
---|---|
To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
Cc: | Dave Cramer <pg(at)fastcrypt(dot)com>, List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102 |
Date: | 2016-01-11 15:21:27 |
Message-ID: | CAB=Je-EqbGdaNauAgpzULSeEBQKw5c-b4GVp9C7k5W4cJGpUXg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
Thomas, as far as I see, you have offending queries and bind values
for them, don't you?
Can you please perform the following dance in psql or pgadmin?
PREPARE prep1207(number,number,number,number,number,number) as -- <--
data types for the bind variables
select .. $1, ... where id=$2; -- <-- your query here
EXPLAIN ANALYZE EXECUTE prep1207(1,2,3,42,100500); -- <-- values for
bind variables
EXPLAIN ANALYZE EXECUTE prep1207(1,2,3,42,100500); -- <-- values for
bind variables
EXPLAIN ANALYZE EXECUTE prep1207(1,2,3,42,100500); -- <-- values for
bind variables
EXPLAIN ANALYZE EXECUTE prep1207(1,2,3,42,100500); -- <-- values for
bind variables
EXPLAIN ANALYZE EXECUTE prep1207(1,2,3,42,100500); -- <-- values for
bind variables
Ideally, it should reproduce the issue. In other words, 5th or 6th
execution should flip to bad plan.
Then share the plan/query.
If table names cannot be made public, you might want try
http://explain.depesz.com/ to anonymize the plan.
Vladimir
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-01-11 15:24:10 | Re: Request - repeat value of \pset title during \watch interations |
Previous Message | Tom Lane | 2016-01-11 15:14:33 | Re: Request - repeat value of \pset title during \watch interations |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2016-01-11 15:38:38 | Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102 |
Previous Message | Dave Cramer | 2016-01-11 14:56:42 | Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102 |