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 <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
