Re: Several issues with postgres_fdw stats import

From: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
To: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Noah Misch <noah(at)leadboat(dot)com>
Subject: Re: Several issues with postgres_fdw stats import
Date: 2026-09-26 11:54:25
Message-ID: CAPmGK14m36AB3FSC3pXuW38jCj9AtDBNG3ab=DnSbFxKid=ZMw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Sep 22, 2026 at 8:35 PM Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> wrote:
> He provided a fix for this as well, which I'm attaching. The fix
> addresses it by switching the userid to the foreign-table owner's
> userid in analyze.c before calling ImportForeignStatistics(). I think
> the fix is also reasonable in that it makes the identity handling
> consistent between the sampling/import methods. So I will push and
> back-patch the fix if no objections from others.

Done. (I know Matheus updated the patch, but what he is proposing
would be rather an improvement, so I will work on it separately.)

Best regards,
Etsuro Fujita

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2026-09-26 11:55:50 Re: Several issues with postgres_fdw stats import
Previous Message Tatsuo Ishii 2026-09-26 11:53:23 Re: Row pattern recognition