doc: Explain that ANALYZE ignores reject_limit in file_fdw The documentation did not explain that ANALYZE on file_fdw foreign tables ignores reject_limit, which could lead users to expect it to fail when the number of skipped rows exceeded the limit.
Ignoring the limit allows statistics to be collected from valid rows even when the limit is exceeded. These statistics can still be useful for queries using LIMIT, for example, which may finish before encountering enough conversion errors to exceed reject_limit. Document this exception and its rationale. Backpatch to v18, where reject_limit support was added to file_fdw. Author: Ayoub Kazar <[email protected]> Reviewed-by: Fujii Masao <[email protected]> Discussion: https://postgr.es/m/[email protected] Backpatch-through: 18 Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/7eac6c699a3ff1c53448e751d8eed1819d62df09 Modified Files -------------- contrib/file_fdw/file_fdw.c | 6 +++++- doc/src/sgml/file-fdw.sgml | 5 ++++- 2 files changed, 9 insertions(+), 2 deletions(-)
