pgsql: Allow parallel create index to accumulate buffer usage stats. - Mailing list pgsql-committers

From Amit Kapila
Subject pgsql: Allow parallel create index to accumulate buffer usage stats.
Date
Msg-id E1jMP2S-0004b8-2m@gemulon.postgresql.org
Whole thread Raw
List 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_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/f179e9f01b65dd880b204599187ffff29ecba91e

Modified Files
--------------
src/backend/access/nbtree/nbtsort.c | 39 +++++++++++++++++++++++++++++++++++++
1 file changed, 39 insertions(+)


pgsql-committers by date:

Previous
From: Fujii Masao
Date:
Subject: pgsql: Add note in pg_stat_statements documentation about planning stat
Next
From: Michael Paquier
Date:
Subject: Re: pgsql: Implement waiting for given lsn at transaction start