Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id E69B7B5DBD9 for ; Fri, 7 Oct 2011 09:56:52 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 69346-09 for ; Fri, 7 Oct 2011 12:56:46 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from fetter.org (173-164-140-181-SFBA.hfc.comcastbusiness.net [173.164.140.181]) by mail.postgresql.org (Postfix) with ESMTP id 71BDBB5DBE4 for ; Fri, 7 Oct 2011 09:56:46 -0300 (ADT) Received: by fetter.org (Postfix, from userid 500) id 331373C02CA; Fri, 7 Oct 2011 05:56:46 -0700 (PDT) Date: Fri, 7 Oct 2011 05:56:46 -0700 From: David Fetter To: Etsuro Fujita Cc: Alvaro Herrera , Tom Lane , Marti Raudsepp , Pg Hackers Subject: Re: WIP: Collecting statistics on CSV file data Message-ID: <20111007125646.GF740@fetter.org> References: <4E6DE18B.4010505@lab.ntt.co.jp> <8240.1316531585@sss.pgh.pa.us> <20110921002232.GA18333@fetter.org> <1316566782-sup-2678@alvh.no-ip.org> <4E8EDDF8.9080803@lab.ntt.co.jp> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4E8EDDF8.9080803@lab.ntt.co.jp> User-Agent: Mutt/1.5.21 (2010-09-15) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.918 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RDNS_DYNAMIC=0.982 X-Spam-Level: X-Archive-Number: 201110/364 X-Sequence-Number: 196170 On Fri, Oct 07, 2011 at 08:09:44PM +0900, Etsuro Fujita wrote: > 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. OK > (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.) Look into the "virtual index interface" from Informix. We might want to start a wiki page on this. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate