Request a Demo
Home   >   mailing lists

Re: Several issues with postgres_fdw stats import - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: Several issues with postgres_fdw stats import
Date
Msg-id CAPmGK14OBMkMEkanHdA9+JdrZLGzfNRcEVmb6K4DtDe_CTTTqw@mail.gmail.com
Whole thread
Responses Re: Several issues with postgres_fdw stats import
List pgsql-hackers
Tree view 
On Fri, Sep 11, 2026 at 12:46 AM Corey Huinker <corey.huinker@gmail.com> wrote:
> On Thu, Sep 10, 2026 at 11:02 AM Etsuro Fujita <etsuro.fujita@gmail.com> wrote:

>> From a cost calculation perspective, I think it's appropriate to use
>> the imported relpages as-is, as it's used to estimate the cost for
>> remote operations, not local ones, and thus we should actually instead
>> fix the normal-ANALYZE handling to calculate the size based on the
>> remote definition of block size.
>
> +1

I expanded a comment to mention this.  Attached is a patch for that.
I will push and back-patch the patch if no objections.

Best regards,
Etsuro Fujita
Attachment

pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Several issues with postgres_fdw stats import
Next
From: Yao Feng
Date:
Subject: Re: [GSoC 2026] - B-tree Index Bloat Reduction - Approach & Questions