Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17870: Analyze on remote postgresql_fdw table never finish - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #17870: Analyze on remote postgresql_fdw table never finish
Date
Msg-id 3169077.1679928193@sss.pgh.pa.us
Whole thread Raw
In response to BUG #17870: Analyze on remote postgresql_fdw table never finish  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17870: Analyze on remote postgresql_fdw table never finish  (Maxim Boguk <maxim.boguk@gmail.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Andrey Lizenko
Date:
Subject: Re: BUG #17863: Unable to restore dump 12.12 -> 15.2
Next
From: Tom Lane
Date:
Subject: Re: BUG #17872: Dropping an attribute of a composite type breaks indexes over the type silently