model-writtenrun 6002 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Yusuke Egashira reported that PostgreSQL 14 on Windows crashed when pg_stat_statements read a query-text file exceeding 2GB, tracing the failure to the Windows read() argument limit in #1.
- Juan José Santamaría Flecha proposed limiting the allocation to MaxAllocSize in #2 and supplied that one-line change in #4.
- Tom Lane rejected that restriction in #5 because it would make pg_stat_statements fail above 1GB on every platform; he proposed chunked reads and separately raised the need to control total query-text storage.
- Tom Lane supplied the replacement patch in #8, retaining large-file support while reading 1GB at a time to stay below Windows' limit and favor filesystem-block multiples.
- After acknowledging Juan José Santamaría Flecha's testing in #9, Tom Lane committed #8 unchanged as a667b06683, with backports to all supported branches; limiting total query-text storage remained outside this fix.
- Yusuke Egashira confirmed that the patched environment no longer crashed in #11, closing the thread with the crash fix landed and the broader storage-size concern unresolved.