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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: maxim(dot)boguk(at)gmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17870: Analyze on remote postgresql_fdw table never finish
Date: 2023-03-27 14:43:13
Message-ID: 3169077.1679928193@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2023-03-27 14:49:39 Re: BUG #17872: Dropping an attribute of a composite type breaks indexes over the type silently
Previous Message Andrey Lizenko 2023-03-27 14:38:40 Re: BUG #17863: Unable to restore dump 12.12 -> 15.2