On Thu, Nov 5, 2026 at 9:40 AM Ayoub Kazar <[email protected]> wrote: > However, ANALYZE silently ignores reject_limit, skips all > malformed rows, and finishes with a NOTICE.
Personally, I'd prefer to keep this behavior. Statistics based on valid rows are still useful even when the number of errors exceeds reject_limit. Queries may still succeed, for example, when using LIMIT, whereas aborting ANALYZE would leave the statistics outdated. So I think ANALYZE should continue to ignore reject_limit. Thought? If we agree, how about documenting this exception and adding a comment in file_acquire_sample_rows() explaining why reject_limit is not enforced? Regards, -- Fujii Masao
