model-writtenrun 8787 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Thomas Munro proposed replacing seek-and-I/O sequences with pg_pread() and pg_pwrite() in SLRU, heap rewriting and WAL receiving in #1.
- Andres Freund reviewed the series in #2, proposed replacing the remaining SLRU file-size seek with an fstat-based helper, and requested additional cleanup in walsender, miscinit and pg_stat_statements.
- Thomas committed the heap-rewrite and WAL-receiver patches from #1, together with additional miscinit and pg_stat_statements conversions, as 701a51fd4e; his remaining series in #3 introduced pg_fstat_size() for SLRU and walsender despite measurements showing fstat() slower than lseek(), while deferring changes to FileSize() pending size caching.
- Michael Paquier raised Windows large-file limitations in #4, Thomas proposed GetFileSizeEx() in #5, and Alvaro Herrera argued for an implementation-independent helper name in #6; Thomas incorporated these ideas into the int64-returning pg_file_size() series in #7.
- Michael reviewed the revised series in #8, requested frontend availability and an explanation of the Windows implementation, identified a commit-message typo, and suggested further conversions in pg_receivewal and pg_rewind.
- Alvaro questioned paying the fstat() overhead when callers did not need to preserve file position and proposed a caller-selectable lseek() path plus documentation of the error return in #9.
- After several months, Thomas committed only the SLRU positional-I/O portion of #7 as e2b37d9e7c and reported it in #10, leaving the central file-size helper and dependent SLRU and walsender changes unresolved.