Re: WIP: Collecting statistics on CSV file data

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 <david@fetter.org> 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