Message-ID: <4E8EDDF8.9080803@lab.ntt.co.jp>
Date: Fri, 07 Oct 2011 20:09:44 +0900
From: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; ja;
	rv:1.9.2.9) Gecko/20100915 Thunderbird/3.1.4
MIME-Version: 1.0
To: Alvaro Herrera <alvherre@commandprompt.com>
CC: David Fetter <david@fetter.org>, Tom Lane <tgl@sss.pgh.pa.us>,
	Marti Raudsepp <marti@juffo.org>, Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: WIP: Collecting statistics on CSV file data
References: <4E6DE18B.4010505@lab.ntt.co.jp>
	<CABRT9RA0Xq+jaN115BBTotrBUgQY0k7bvQJSLWQd8Ug1ohUiwg@mail.gmail.com>
	<8240.1316531585@sss.pgh.pa.us> <20110921002232.GA18333@fetter.org>
	<1316566782-sup-2678@alvh.no-ip.org>
In-Reply-To: <1316566782-sup-2678@alvh.no-ip.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

I'm very sorry for the late reply.

(2011/09/21 10:00), Alvaro Herrera wrote:
> Excerpts from David Fetter's message of mar sep 20 21:22:32 -0300 2011:
>> On Tue, Sep 20, 2011 at 11:13:05AM -0400, Tom Lane wrote:
>
>>> Probably a more interesting question is why we wouldn't change
>>> autovacuum so that it calls this automatically for foreign tables.
>>
>> How about a per-table setting that tells autovacuum whether to do
>> this?
>
> Seems reasonable.  Have autovacuum assume that foreign tables are not to
> be analyzed, unless some reloption is set.

Thank you for the comments. I'd like to leave that feature for future work.

(But this is BTW. I'm interested in developing CREATE FOREIGN INDEX. 
I've examined whether there are discussions about the design and 
implementation of it in the archive, but could not find information. If 
you know anything, please tell me.)

Best regards,
Etsuro Fujita