Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower

From:	David Rowley <dgrowleyml(at)gmail(dot)com>
To:	william(dot)duclot(at)gmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject:	Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower
Date:	2022-07-07 00:46:17
Message-ID:	CAApHDvpF2-gtXbJCpnVBbpOZw14rkKbexPcKi+eAgMMuorc6Ew@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2022-07-05 22:13:15 from PG Bug reporting form <noreply(at)postgresql(dot)org>  2022-07-06 22:07:46 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>   2022-07-07 00:46:46 from Andres Freund <andres(at)anarazel(dot)de>    2022-07-07 01:54:46 from David Rowley <dgrowleyml(at)gmail(dot)com>    2022-07-07 03:13:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2022-07-07 04:36:56 from Andres Freund <andres(at)anarazel(dot)de>      2022-07-07 18:02:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>  2022-07-07 00:23:01 from David Rowley <dgrowleyml(at)gmail(dot)com>   2022-07-07 00:46:17 from David Rowley <dgrowleyml(at)gmail(dot)com>   2022-07-07 03:06:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2022-07-07 03:31:30 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎     2022-07-07 03:50:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2023-07-05 23:55:36 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎       2023-07-06 09:26:55 from Richard Guo <guofenglinux(at)gmail(dot)com>        2023-07-07 07:02:59 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎         2023-07-10 02:14:04 from David Rowley <dgrowleyml(at)gmail(dot)com>          2023-07-10 06:39:27 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎           2023-07-26 03:17:44 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎           2023-09-26 13:42:32 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎            2023-09-28 03:22:38 from Richard Guo <guofenglinux(at)gmail(dot)com>             2023-09-28 03:51:38 from David Rowley <dgrowleyml(at)gmail(dot)com>              2023-10-08 08:26:43 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎               2023-10-24 04:25:12 from Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                2023-11-01 02:20:49 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                 2023-11-29 00:48:10 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                  2023-12-01 10:07:03 from Richard Guo <guofenglinux(at)gmail(dot)com> 📎                   2023-12-07 11:04:37 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                    2023-12-27 11:20:38 from Andy Fan <zhihuifan1213(at)163(dot)com>                     2023-12-27 11:58:26 from Richard Guo <guofenglinux(at)gmail(dot)com>                      2023-12-29 01:25:09 from Andy Fan <zhihuifan1213(at)163(dot)com>                     2024-01-22 11:01:09 from David Rowley <dgrowleyml(at)gmail(dot)com>                    2024-01-22 04:31:46 from Peter Smith <smithpb2250(at)gmail(dot)com>                     2024-01-22 11:11:29 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                      2024-01-23 05:10:52 from David Rowley <dgrowleyml(at)gmail(dot)com>                       2024-01-23 06:16:11 from Richard Guo <guofenglinux(at)gmail(dot)com>
Lists:	pgsql-bugs pgsql-hackers

In response to

• Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower at 2022-07-07 00:23:01 from David Rowley

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	Andres Freund	2022-07-07 00:46:46	Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower
Previous Message	David Rowley	2022-07-07 00:23:01	Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Andres Freund	2022-07-07 00:46:46	Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower
Previous Message	David Rowley	2022-07-07 00:23:01	Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower