| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | Matheus Martin <matheus(dot)martin(at)voidbridge(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Missing query plan for auto_explain. |
| Date: | 2022-08-30 17:07:51 |
| Message-ID: | 3695159.1661879271@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> On 2022-Aug-30, Matheus Martin wrote:
>> Good idea on using an actual prepared statement but unfortunately it didn't
>> produce any different result.
> I should have also mentioned to try the EXPLAIN EXECUTE six times and
> see if the last one produces a different plan. That's when it switches
> from planning every time to planning with generic arguments, as I
> recall.
In recent versions you can bypass that with
SET plan_cache_mode = force_generic_plan;
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kristjan Mustkivi | 2022-08-31 13:03:31 | CREATE SUBSCRIPTION not picking up .pgpass while psql does |
| Previous Message | Alvaro Herrera | 2022-08-30 16:45:12 | Re: Missing query plan for auto_explain. |