Re: Speed up COPY FROM text/CSV parsing using SIMD

2025-08-21 Thread KAZAR Ayoub
> On Thu, 14 Aug 2025 at 18:00, KAZAR Ayoub wrote: > >> Thanks for running that benchmark! Would you mind sharing a reproducer > >> for the regression you observed? > > > > Of course, I attached the sql to generate the text and csv test files. > > If

Re: Speed up COPY FROM text/CSV parsing using SIMD

2025-08-14 Thread KAZAR Ayoub
> Hi, > > On Thu, 14 Aug 2025 at 05:25, KAZAR Ayoub wrote: > > > > Following Nazir's findings about 4096 bytes being the performant line > length, I did more benchmarks from my side on both TEXT and CSV formats > with two different cases of normal data (no special

Re: Speed up COPY FROM text/CSV parsing using SIMD

2025-08-13 Thread KAZAR Ayoub
Following Nazir's findings about 4096 bytes being the performant line length, I did more benchmarks from my side on both TEXT and CSV formats with two different cases of normal data (no special characters) and data with many special characters. Results are con good as expected and similar to previ

Re: Experimenting with hash join prefetch

2025-07-24 Thread KAZAR Ayoub
Hi, I thought it might be interesting to revive this thread because the improvements i saw from Thomas’s work, and even just simple prefetching of bucket headers for the probe phase in-memory (to see the effect of prefetching), are still showing nice improvements. Here are some results for simple

Questions About TODO: Issuing NOTICEs for row count differences in EXPLAIN ANALYZE

2024-10-28 Thread KAZAR Ayoub
Hello Hackers, I am currently looking into the following TODO item, "Have EXPLAIN ANALYZE issue NOTICE messages when the estimated and actual row counts differ by a specified percentage." What's the current status of this TODO, and is there any prior discussion or rationale behind it ? Specifically