From: Julien Rouhaud <rjuju123@gmail.com>
To: dafoer_x@163.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17650: For the sixth time, the clipping function in the 120 partition table planning stage fails
Date: Tue, 18 Oct 2022 21:50:17 +0800
Message-ID: <20221018135017.cefttdymnmooh4af@jrouhaud> (raw)
In-Reply-To: <17650-4523221bc4eb0c33@postgresql.org>
References: <17650-4523221bc4eb0c33@postgresql.org>
Hi,
On Tue, Oct 18, 2022 at 01:11:13PM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 17650
> Logged by: dafoer
> Email address: dafoer_x@163.com
> PostgreSQL version: 14.0
Unrelated but you should definitely update to the latest minor version,
currently 14.5
> Operating system: centos7.6
> Description:
>
> The clipping function of partition table cannot be carried out normally in
> the planning stage. The extension protocol cannot be clipped in the sixth
> execution. When concurrency is high, lock contention is serious
I'm not sure I fully understand. Are you saying that partition pruning (1)
doesn't happen after 6 execution of a prepared statement? If yes, it's not a
bug but a known behavior of generic plans. You can dynamically set
plan_cache_mode to force_custom_plan for the cases where generic plans are
known to behave poorly.
[1] https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITION-PRUNING
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: rjuju123@gmail.com, dafoer_x@163.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17650: For the sixth time, the clipping function in the 120 partition table planning stage fails
In-Reply-To: <20221018135017.cefttdymnmooh4af@jrouhaud>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox