Closed
4 / 44 of 4 issues completedLabels
Description
Summary
Run one combined benchmark on the commit planned for 4.2.0, and release 4.2.0 on that commit unless the results show a major problem. Collecting the measurements in one run keeps the cost and effort to a single run, and ties the published results to the released commit.
Sub-issues
- Benchmark the temporal type conversion changes of 4.2.0 #1287: the temporal type conversion changes, measured on 4.2.0 only (the PRs' local measurements give the comparison). It needs a
temporalshape in the harness, merged before the commit planned for 4.2.0. - Benchmark chunked reads of a result larger than host memory #1162: chunked reads of a result larger than host memory (100 million rows).
- Size the asyncio filesystem's parallel requests by max_workers instead of the default executor #1159: the asyncio filesystem's parallel requests, sized by
max_workers. The change is merged, and this issue stays open for the measurement.
Plan
- Use Spot hosts, on the same day:
- an
r7g.2xlargestack for the cursor andread_sql_query()cases, including Benchmark the temporal type conversion changes of 4.2.0 #1287 and Benchmark chunked reads of a result larger than host memory #1162; - a
c8gn.2xlargestack for the filesystem suite (Size the asyncio filesystem's parallel requests by max_workers instead of the default executor #1159).
- an
- Measure the commit planned for 4.2.0. Unless the results show a major problem, release 4.2.0 on that commit. Improvements found in the results are filed as issues and made after the release.
- After the run:
- Decide the
AioS3FileSystemdefault for writes and copies (Size the asyncio filesystem's parallel requests by max_workers instead of the default executor #1159, following Benchmark S3ThreadPoolExecutor vs S3AioExecutor before defaulting to async #685). - If the results hold, close larger than memory queries? #61 (through Benchmark chunked reads of a result larger than host memory #1162) and SQLAlchemy + Pandas very slow when compared to AWS Wrangler #254.
- Record the results under
benchmarks/history/and inbenchmarks/RESULTS.md.
- Decide the
Activity
Say that 4.2.0 is tagged on baee716, not on the measured commit (GH-1288
Qualify the read, temporal UNLOAD, and xxlarge Athena time statements (…
Scope the 8-worker non-regression heading to 256 MiB and larger (GH-1288
State the 256 MiB and larger filesystem results against sync, with th…
laughingman7743 commentedon Oct 19, 2026
Done. All sub-issues are closed.
r7g.2xlargehosts and 16 filesystem jobs on onec8gn.2xlargehost, all on 2026-10-19, measuring9e99caa8.baee716c. The first tag on9e99caa8failed a Python 3.13 test in the release gate (test_open_async_cancelled fails when another object emits a ResourceWarning during gc.collect() #1309, fixed by Count only the file's ResourceWarning in test_open_async_cancelled #1311, test-only), so the release commit differs from the measured commit only in that test file.RESULTS.mdare in Record the PyAthena 4.2.0 benchmark runs #1310.