Re: Import Statistics in postgres_fdw before resorting to sampling.

2025-11-02 Thread Corey Huinker
> > I am a bit uncomfortable regarding the design you are using here, > where the ImportStatistics callback, if defined, takes priority over > the existing AnalyzeForeignTable, especially regarding the fact that > both callbacks attempt to retrieve the same data, except that the > existing callback

Re: Import Statistics in postgres_fdw before resorting to sampling.

2025-10-20 Thread Michael Paquier
On Mon, Oct 20, 2025 at 03:45:14PM +0900, Michael Paquier wrote: > On Sat, Oct 18, 2025 at 08:32:24PM -0400, Corey Huinker wrote: > > Rebased again. > > Hearing an opinion from Fujita-san would be interesting here, so I am > adding him in CC. I have been looking a little bit at this patch. By th

Re: Import Statistics in postgres_fdw before resorting to sampling.

2025-10-19 Thread Michael Paquier
On Sat, Oct 18, 2025 at 08:32:24PM -0400, Corey Huinker wrote: > Rebased again. Hearing an opinion from Fujita-san would be interesting here, so I am adding him in CC. I have been looking a little bit at this patch. + ImportStatistics_function ImportStatistics; All FDW callbacks are docum

Re: Import Statistics in postgres_fdw before resorting to sampling.

2025-10-18 Thread Corey Huinker
On Fri, Sep 12, 2025 at 1:17 AM Corey Huinker wrote: > Rebased. > Rebased again. From f44b3223c1a15fd7213b2227669ff400f8c01efa Mon Sep 17 00:00:00 2001 From: Corey Huinker Date: Thu, 7 Aug 2025 23:58:38 -0400 Subject: [PATCH v3] Add remote statistics fetching to postgres_fdw. This adds the abi

Re: Import Statistics in postgres_fdw before resorting to sampling.

2025-09-11 Thread Corey Huinker
Rebased. From 85f4d02ccef96d80063457a7870caf5f94e12859 Mon Sep 17 00:00:00 2001 From: Corey Huinker Date: Thu, 7 Aug 2025 23:58:38 -0400 Subject: [PATCH v2] Add remote statistics fetching to postgres_fdw. This adds the ability to fetch and import statistics from a remote server table table rather

Re: Import Statistics in postgres_fdw before resorting to sampling.

2025-08-14 Thread Corey Huinker
> > > This isn't a full review. I looked at the patches mainly to find out > how does it fit into the current method of analysing a foreign table. > Any degree of review is welcome. We're chasing views, reviews, etc. > Right now, do_analyze_rel() is called with FDW specific acquireFunc, > which

Re: Import Statistics in postgres_fdw before resorting to sampling.

2025-08-14 Thread Ashutosh Bapat
On Tue, Aug 12, 2025 at 10:33 PM Corey Huinker wrote: > > > Attached is my current work on adding remote fetching of statistics to > postgres_fdw, and opening the possibility of doing so to other foreign data > wrappers. > > This involves adding two new options to postgres_fdw at the server and

Import Statistics in postgres_fdw before resorting to sampling.

2025-08-12 Thread Corey Huinker
Attached is my current work on adding remote fetching of statistics to postgres_fdw, and opening the possibility of doing so to other foreign data wrappers. This involves adding two new options to postgres_fdw at the server and table level. The first option, fetch_stats, defaults to true at both