From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp> |
Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Marti Raudsepp <marti(at)juffo(dot)org>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: WIP: Collecting statistics on CSV file data |
Date: | 2011-10-07 12:56:46 |
Message-ID: | 20111007125646.GF740@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Goncharov | 2011-10-07 13:13:54 | Re: libpq, PQdescribePrepared -> PQftype, PQfmod, no PQnullable |
Previous Message | Merlin Moncure | 2011-10-07 12:39:57 | Re: libpq, PQdescribePrepared -> PQftype, PQfmod, no PQnullable |