From: David Fetter <david@fetter.org>
To: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Marti Raudsepp <marti@juffo.org>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: WIP: Collecting statistics on CSV file data
Date: Fri, 7 Oct 2011 05:56:46 -0700
Message-ID: <20111007125646.GF740@fetter.org> (raw)
In-Reply-To: <4E8EDDF8.9080803@lab.ntt.co.jp>
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>
<4E8EDDF8.9080803@lab.ntt.co.jp>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: david@fetter.org, fujita.etsuro@lab.ntt.co.jp, alvherre@commandprompt.com, tgl@sss.pgh.pa.us, marti@juffo.org
Subject: Re: WIP: Collecting statistics on CSV file data
In-Reply-To: <20111007125646.GF740@fetter.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox