Re: BUG #17870: Analyze on remote postgresql_fdw table never finish

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: maxim.boguk@gmail.com

Cc: pgsql-bugs@lists.postgresql.org

Date: 2023-03-27T14:43:13Z

Lists: pgsql-bugs

PG Bug reporting form <noreply@postgresql.org> writes:
> Is it expected that the analyze of foreign table will fetch whole table to
> local size (quite a task for 2TB table)?

Yes.  There's an improvement in the works for v16 (8ad51b5f4).

			regards, tom lane