Re: Allow pg_dump --statistics-only to dump foreign table statistics?

From: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org, corey(dot)huinker(at)gmail(dot)com, pgsql(at)j-davis(dot)com
Subject: Re: Allow pg_dump --statistics-only to dump foreign table statistics?
Date: 2025-06-17 03:34:28
Message-ID: ec4d15b6-64ff-4114-a5d2-9263263e4198@oss.nttdata.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2025/06/14 7:31, Nathan Bossart wrote:
> On Fri, Jun 13, 2025 at 04:19:26PM +0900, Fujii Masao wrote:
>> I noticed that pg_restore_relation|attribute_stats() can restore statistics
>> for foreign tables, but pg_dump --statistics-only doesn't include them.
>> Is there a reason why pg_dump skips statistics for foreign tables?
>> Are there any risks or concerns around including them?
>
> Isn't this applicable to --with-statistics, too?

Yes, it applies to --with-statistics as well.

Regards,

--
Fujii Masao
NTT DATA Japan Corporation

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2025-06-17 03:39:16 Re: Allow pg_dump --statistics-only to dump foreign table statistics?
Previous Message Hayato Kuroda (Fujitsu) 2025-06-17 03:21:19 RE: pg_recvlogical cannot create slots with failover=true