Message-ID: <4E9EA05E.7030005@lab.ntt.co.jp>
Date: Wed, 19 Oct 2011 19:03:10 +0900
From: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; ja;
	rv:1.9.2.9) Gecko/20100915 Thunderbird/3.1.4
MIME-Version: 1.0
To: Leonardo Francalanci <m_lists@yahoo.it>
CC: Shigeru Hanada <shigeru.hanada@gmail.com>,
	"pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Subject: Re: WIP: Collecting statistics on CSV file data
References: <4E6DE18B.4010505@lab.ntt.co.jp> <4E7861C1.2000607@gmail.com>
	<4E8EC1D8.3080700@lab.ntt.co.jp> <4E9C6573.8050507@gmail.com>
	<1318923174.20848.YahooMailNeo@web29006.mail.ird.yahoo.com>
In-Reply-To: <1318923174.20848.YahooMailNeo@web29006.mail.ird.yahoo.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

(2011/10/18 16:32), Leonardo Francalanci wrote:
>> New API AnalyzeForeignTable
>
> I didn't look at the patch, but I'm using CSV foreign tables with named pipes
> to get near-realtime KPI calculated by postgresql. Of course, pipes can be
> read just once, so I wouldn't want an "automatic analyze" of foreign tables...

The patch does not analyze on foreign tables automatically. (The issue 
of auto-analyze on foreign tables has been discussed. Please refer to [1].)

[1] http://archives.postgresql.org/pgsql-hackers/2011-09/msg00992.php

Best regards,
Etsuro Fujita