Re: WIP: Collecting statistics on CSV file data - Mailing list pgsql-hackers

From Shigeru Hanada
Subject Re: WIP: Collecting statistics on CSV file data
Date
Msg-id CAEZqfEdUnvyQsJ_hu6NxKfk4xhc+EifZxukGoKAY+2_DaesJ3w@mail.gmail.com
Whole thread Raw
In response to Re: WIP: Collecting statistics on CSV file data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sat, Apr 7, 2012 at 4:19 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Shigeru HANADA <shigeru.hanada@gmail.com> writes:
>> Just after my post, Fujita-san posted another v7 patch[1], so I merged
>> v7 patches into v8 patch.
>
> I've committed a modified version of this, but right after pushing it
> I had a better idea about what the AnalyzeForeignTable API should do.
> An issue that I'd not previously figured out is how analysis of an
> inheritance tree could deal with foreign-table members, because it wants
> to estimate the members' sizes before collecting the actual sample rows.
> However, given that we've got the work split into a precheck phase and
> a sample collection phase, that's not hard to solve: we could insist
> that the FDW give back a size estimate in the precheck phase not the
> sample collection phase.  I'm off to fix that up ...

Thanks.  I'll improve pgsql_fdw so that it can collect statistics of
foreign data with this new API.

Regards,
--
Shigeru Hanada


pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: Re: Range Types regression failure
Next
From: Shigeru HANADA
Date:
Subject: Re: pgsql_fdw, FDW for PostgreSQL server