From: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
To: 'Shigeru HANADA' <shigeru.hanada@gmail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: WIP: Collecting statistics on CSV file data
Date: Mon, 9 Apr 2012 11:55:29 +0900
Message-ID: <004201cd15fc$38bdd800$aa398800$@lab.ntt.co.jp> (raw)
In-Reply-To: <12199.1333739991@sss.pgh.pa.us>
References: <4E6DE18B.4010505@lab.ntt.co.jp>
<4E7861C1.2000607@gmail.com>
<4E8EC1D8.3080700@lab.ntt.co.jp>
<4E9C6573.8050507@gmail.com>
<4E9FF04B.3050504@lab.ntt.co.jp>
<4EB7C07A.5030205@gmail.com>
<4EC60883.2050905@lab.ntt.co.jp>
<4EC648CA.5050904@gmail.com>
<4EC9CBC5.3070500@lab.ntt.co.jp>
<4EE1FC38.5080707@lab.ntt.co.jp>
<4EE5D862.1080809@gmail.com>
<4EE74C5F.3000309@lab.ntt.co.jp>
<4F7D8BBF.4050004@gmail.com>
<4F7E57D9.3000807@gmail.com>
<12199.1333739991@sss.pgh.pa.us>
Thanks!
Best regards,
Etsuro Fujita
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Saturday, April 07, 2012 4:20 AM
To: Shigeru HANADA
Cc: Etsuro Fujita; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] WIP: Collecting statistics on CSV file data
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 ...
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: fujita.etsuro@lab.ntt.co.jp, tgl@sss.pgh.pa.us, shigeru.hanada@gmail.com
Subject: Re: WIP: Collecting statistics on CSV file data
In-Reply-To: <004201cd15fc$38bdd800$aa398800$@lab.ntt.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox