pgsql: Provide API for streaming relation data.

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема pgsql: Provide API for streaming relation data.
Дата
Msg-id E1rrcnJ-0007qm-DW@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Provide API for streaming relation data.

Introduce an abstraction allowing relation data to be accessed as a
stream of buffers, with an implementation that is more efficient than
the equivalent sequence of ReadBuffer() calls.

Client code supplies a callback that can say which block number it wants
next, and then consumes individual buffers one at a time from the
stream.  This division puts read_stream.c in control of how far ahead it
can see and allows it to read clusters of neighboring blocks with
StartReadBuffers().  It also issues POSIX_FADV_WILLNEED advice ahead of
time when random access is detected.

Other variants of I/O stream will be proposed in future work (for
example to support recovery, whose LsnReadQueue device in
xlogprefetcher.c is a distant cousin of this code and should eventually
be replaced by this), but this basic API is sufficient for many common
executor usage patterns involving predictable access to a single fork of
a single relation.

Several patches using this API are proposed separately.

This stream concept is loosely based on ideas from Andres Freund on how
we should pave the way for later work on asynchronous I/O.

Author: Thomas Munro <thomas.munro@gmail.com>
Author: Heikki Linnakangas <hlinnaka@iki.fi> (contributions)
Author: Melanie Plageman <melanieplageman@gmail.com> (contributions)
Suggested-by: Andres Freund <andres@anarazel.de>
Reviewed-by: Heikki Linnakangas <hlinnaka@iki.fi>
Reviewed-by: Melanie Plageman <melanieplageman@gmail.com>
Reviewed-by: Nazir Bilal Yavuz <byavuz81@gmail.com>
Reviewed-by: Andres Freund <andres@anarazel.de>
Tested-by: Tomas Vondra <tomas.vondra@enterprisedb.com>
Discussion: https://postgr.es/m/CA+hUKGJkOiOCa+mag4BF+zHo7qo=o9CFheB8=g6uT5TUm2gkvA@mail.gmail.com

Branch
------
master

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

Modified Files
--------------
src/backend/storage/Makefile          |   2 +-
src/backend/storage/aio/Makefile      |  14 +
src/backend/storage/aio/meson.build   |   5 +
src/backend/storage/aio/read_stream.c | 812 ++++++++++++++++++++++++++++++++++
src/backend/storage/meson.build       |   1 +
src/include/storage/read_stream.h     |  63 +++
src/tools/pgindent/typedefs.list      |   2 +
7 files changed, 898 insertions(+), 1 deletion(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: [MASSMAIL]pgsql: Don't use the pg_am system catalog in new test
Следующее
От: Robert Haas
Дата:
Сообщение: pgsql: Expose PQsocketPoll via libpq