Postgres Pro
Downloads
Home   >   mailing lists

Re: Querying one partition in a function takes locks on all partitions - Mailing list pgsql-general

From David G. Johnston
Subject Re: Querying one partition in a function takes locks on all partitions
Date
Msg-id CAKFQuwbpQY9SV0vdWq7fyLk6pEOsDV3hprW7u1-_gQVGwU557g@mail.gmail.com
Whole thread Raw
In response to Re: Querying one partition in a function takes locks on all partitions  (Renan Alves Fonseca <renanfonseca@gmail.com>)
List pgsql-general
Tree view
On Mon, Mar 31, 2025 at 9:42 AM Renan Alves Fonseca <renanfonseca@gmail.com> wrote:
I'm not sure if we should mention the fix or if we should mention a
workaround...

Workarounds are ok but my observation is that "this may change in the future" comments are pointless and should be stricken from the manual because people are bad at predicting the future.  Just document what is and don't string people along.  We never go back to old releases and say "This was fixed in v17."

David J.

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Querying one partition in a function takes locks on all partitions
Next
From: Tom Lane
Date:
Subject: Re: Querying one partition in a function takes locks on all partitions