CONNECTED RESEARCH

Knowledge map

Explore research through connected companies, technologies and questions. Every relationship links to its evidence.

55 / 55 articles with reviewed reader guides · 202 reviewed relationships

Dual row_no and chunk_no cursor

Dual row_no and chunk_no cursorDual row_no and chunk_no curread_research_rows chunked readerread_research_rows chunked r

Select a connected node to continue exploring. Open the evidence below to distinguish reporting, analysis and hypotheses.

Reported evidence

read_research_rows chunked reader → uses → Dual row_no and chunk_no cursor

The reader advances by both row number and chunk number, allowing it to resume within a record while distinguishing chunks belonging to different records.

Read the evidence
The read_research_rows implementation first serializes each row with row_to_json(source)::text, then obtains row_no through stable ordering; each row is split into 8,192-character chunks, with at most eight chunks fetched each time. The outer cursor stores both row_no and chunk_no and continues reading after the last returned chunk. Recording only the row number would omit subsequent chunks of the same row, while recording only the chunk number would not distinguish multiple rows.

[S2] Aperture Intelligence

Read the full research

Connected research

cloud

Aurora Data API Responses Exceeding 1 MiB Cause Admin 502 Errors: Our Reproduction and Chunked-Read Fix

Why did Aperture’s research list return 502 after successful login, and how can oversized records be read without losing audit evidence or mixing snapshots?

A measured incident review with an implementation using 8,192-character chunks, at most eight chunks per call, a row-and-chunk cursor, and a caller-managed Repeatable Read transaction. It also provides PostgreSQL regression tests and separate production browser verification.