From: | Amit Kapila <akapila(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Allow parallel create index to accumulate buffer usage stats. |
Date: | 2020-04-09 04:43:40 |
Message-ID: | E1jMP2S-0004b5-2F@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Allow parallel create index to accumulate buffer usage stats.
Currently, we don't account for buffer usage incurred by parallel workers
for parallel create index. This commit allows each worker to record the
buffer usage stats and leader backend to accumulate that stats at the
end of the operation. This will allow pg_stat_statements to display
correct buffer usage stats for (parallel) create index command.
Reported-by: Julien Rouhaud
Author: Sawada Masahiko
Reviewed-by: Dilip Kumar, Julien Rouhaud and Amit Kapila
Backpatch-through: 11, where this was introduced
Discussion: https://postgr.es/m/20200328151721.GB12854@nol
Branch
------
REL_12_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/13823ad3b012cfaf986ee4dfbd60190ca07187f1
Modified Files
--------------
src/backend/access/nbtree/nbtsort.c | 39 +++++++++++++++++++++++++++++++++++++
1 file changed, 39 insertions(+)
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2020-04-09 06:52:26 | Re: pgsql: Implement waiting for given lsn at transaction start |
Previous Message | Fujii Masao | 2020-04-09 03:57:19 | pgsql: Add note in pg_stat_statements documentation about planning stat |