diff options
| author | David Rowley <drowley@postgresql.org> | 2025-04-02 14:05:15 +1300 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2025-04-02 14:05:15 +1300 |
| commit | ebbdaf1fd59d3bad4bb0aee346ad6f8a225549d1 (patch) | |
| tree | 9b6f0fd3adc182eeb16b17b19ac8e95ef0c0c268 | |
| parent | e4440a73c7ef5f19da9501eca06b61e252d392d0 (diff) | |
Doc: add information about partition locking
The documentation around locking of partitions for the executor startup
phase of run-time partition pruning wasn't clear about which partitions
were being locked. Fix that.
Reviewed-by: Tender Wang <tndrwang@gmail.com>
Discussion: https://postgr.es/m/CAApHDvp738G75HfkKcfXaf3a8s%3D6mmtOLh46tMD0D2hAo1UCzA%40mail.gmail.com
Backpatch-through: 13
| -rw-r--r-- | doc/src/sgml/ddl.sgml | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 38725a12f6d..e1e31abb321 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -4698,7 +4698,9 @@ EXPLAIN SELECT count(*) FROM measurement WHERE logdate >= DATE '2008-01-01'; It is possible to determine the number of partitions which were removed during this phase by observing the <quote>Subplans Removed</quote> property in the - <command>EXPLAIN</command> output. + <command>EXPLAIN</command> output. It's important to note that any + partitions removed by the partition pruning done at this stage are + still locked at the beginning of execution. </para> </listitem> |