Horton

Use streaming I/O in ANALYZE.

Thomas Munro <tmunro@postgresql.org>

View on postgr.es
Commit: 041b96802efa33d2bc9456f2ad946976b92b5ae1
Author: Thomas Munro <tmunro@postgresql.org>
Date: 2024-04-08T01:16:28Z
Releases: 17.0 
Use streaming I/O in ANALYZE.

The ANALYZE command prefetches and reads sample blocks chosen by a
BlockSampler algorithm. Instead of calling [Prefetch|Read]Buffer() for
each block, ANALYZE now uses the streaming API introduced in b5a9b18cd0.

Author: Nazir Bilal Yavuz <byavuz81@gmail.com>
Reviewed-by: Melanie Plageman <melanieplageman@gmail.com>
Reviewed-by: Andres Freund <andres@anarazel.de>
Reviewed-by: Jakub Wartak <jakub.wartak@enterprisedb.com>
Reviewed-by: Heikki Linnakangas <hlinnaka@iki.fi>
Reviewed-by: Thomas Munro <thomas.munro@gmail.com>
Discussion: https://postgr.es/m/flat/CAN55FZ0UhXqk9v3y-zW_fp4-WCp43V8y0A72xPmLkOM%2B6M%2BmJg%40mail.gmail.com

Files

PathChange+/−
src/backend/access/heap/heapam_handler.c modified +16 −13
src/backend/commands/analyze.c modified +25 −60
src/include/access/heapam.h modified +2 −3

Discussion

Cited messages not in the archive: flat/CAN55FZ0UhXqk9v3y-zW_fp4-WCp43V8y0A72xPmLkOM+6M+mJg@mail.gmail.com