Horton

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

Richard Guo <guofenglinux@gmail.com>

View thread View on postgr.es
From: Richard Guo <guofenglinux@gmail.com>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, william.duclot@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Date: 2023-07-26T03:17:44Z
Lists: pgsql-bugs, pgsql-hackers

Attachments

On Mon, Jul 10, 2023 at 2:39 PM Richard Guo <guofenglinux@gmail.com> wrote:

> Here is v3 patch with regression tests.  I add the new test into the
> group where stats test is in, but I'm not sure if this is the right
> place.
>

cfbot says there is a test failure in postgres_fdw.  So update to v4 to
fix that.

Thanks
Richard

Commits

  1. Add better handling of redundant IS [NOT] NULL quals