]> granicus.if.org Git - postgresql/commit
Allow statistics to be collected for foreign tables.
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 6 Apr 2012 19:02:35 +0000 (15:02 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 6 Apr 2012 19:02:35 +0000 (15:02 -0400)
commit263d9de66b867b7800fac82c222e004b795b724a
tree4ecc70b6e75339304b2829a2ced3cb084f0aacdb
parent8cb53654dbdb4c386369eb988062d0bbb6de725e
Allow statistics to be collected for foreign tables.

ANALYZE now accepts foreign tables and allows the table's FDW to control
how the sample rows are collected.  (But only manual ANALYZEs will touch
foreign tables, for the moment, since among other things it's not very
clear how to handle remote permissions checks in an auto-analyze.)

contrib/file_fdw is extended to support this.

Etsuro Fujita, reviewed by Shigeru Hanada, some further tweaking by me.
13 files changed:
contrib/file_fdw/file_fdw.c
doc/src/sgml/fdwhandler.sgml
doc/src/sgml/maintenance.sgml
doc/src/sgml/ref/alter_foreign_table.sgml
doc/src/sgml/ref/analyze.sgml
src/backend/commands/analyze.c
src/backend/commands/tablecmds.c
src/bin/psql/describe.c
src/bin/psql/tab-complete.c
src/include/commands/vacuum.h
src/include/foreign/fdwapi.h
src/test/regress/expected/foreign_data.out
src/test/regress/sql/foreign_data.sql