pgsql: doc: Explain that ANALYZE ignores reject_limit in file_fdw

Поиск
Список
Период
Сортировка
Искать

pgsql: doc: Explain that ANALYZE ignores reject_limit in file_fdw

От:
Fujii Masao <fujii@postgresql.org>
Дата:
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 
Reviewed-by: Fujii Masao 
Discussion: https://postgr.es/m/6cc479df-7571-4393-a572-f46dba1bfcbf@data-bene.io
Backpatch-through: 18

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/0b355d4277e76d6ae691855070e20da703789cea

Modified Files
--------------
contrib/file_fdw/file_fdw.c | 6 +++++-
doc/src/sgml/file-fdw.sgml  | 5 ++++-
2 files changed, 9 insertions(+), 2 deletions(-)

Re: pgsql: doc: Explain that ANALYZE ignores reject_limit in file_fdw

От:
Richard Guo <guofenglinux@gmail.com>
Дата:
On Wed, Nov 11, 2026 at 10:07 AM Fujii Masao  wrote:
> doc: Explain that ANALYZE ignores reject_limit in file_fdw

This commit needs a pgindent.

- Richard


Re: pgsql: doc: Explain that ANALYZE ignores reject_limit in file_fdw

От:
Fujii Masao <masao.fujii@gmail.com>
Дата:
On Wed, Nov 11, 2026 at 4:13 PM Richard Guo  wrote:
> This commit needs a pgindent.

Many thanks! I've pushed the fix.

Regards,

-- 
Fujii Masao


FAQ