Postgres module

pipeline_chunked_rows

procedure · 1 overloadsince 0.27.0Source

Makes the next statement to be read deliver its rows count at a time (.ROWS; the last piece may have fewer), then end with a .RESULT that has no rows but the command tag, so a large result never has to fit in memory. It only works before the statement's first result is read. Reverts at the statement's end.

pipeline_chunked_rows :: (p: *Pipeline, count: s64) -> bool

Makes the next statement to be read deliver its rows count at a time (.ROWS; the last piece may have fewer), then end with a .RESULT that has no rows but the command tag, so a large result never has to fit in memory. It only works before the statement's first result is read. Reverts at the statement's end.

Parameters

p: *Pipeline
the pipeline from pipeline_enter.
count: s64
rows per result.

Returns

bool

See also