Re: Querying one partition in a function takes locks on all partitions

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Renan Alves Fonseca <renanfonseca(at)gmail(dot)com>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, Evgeny Morozov <postgresql4(at)realityexists(dot)net>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Querying one partition in a function takes locks on all partitions
Date: 2025-03-31 17:16:01
Message-ID: CAKFQuwbpQY9SV0vdWq7fyLk6pEOsDV3hprW7u1-_gQVGwU557g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Mar 31, 2025 at 9:42 AM Renan Alves Fonseca <renanfonseca(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2025-03-31 17:21:07 Re: Querying one partition in a function takes locks on all partitions
Previous Message Laurenz Albe 2025-03-31 17:08:02 Re: Querying one partition in a function takes locks on all partitions