Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 33BF7B5DC3D for ; Tue, 18 Oct 2011 04:33:03 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 66046-08 for ; Tue, 18 Oct 2011 07:32:56 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from nm11.bullet.mail.ird.yahoo.com (nm11.bullet.mail.ird.yahoo.com [77.238.189.64]) by mail.postgresql.org (Postfix) with SMTP id 63D9AB5DC00 for ; Tue, 18 Oct 2011 04:32:55 -0300 (ADT) Received: from [77.238.189.231] by nm11.bullet.mail.ird.yahoo.com with NNFMP; 18 Oct 2011 07:32:54 -0000 Received: from [212.82.108.242] by tm12.bullet.mail.ird.yahoo.com with NNFMP; 18 Oct 2011 07:32:54 -0000 Received: from [127.0.0.1] by omp1007.mail.ird.yahoo.com with NNFMP; 18 Oct 2011 07:32:54 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 613710.72484.bm@omp1007.mail.ird.yahoo.com Received: (qmail 23027 invoked by uid 60001); 18 Oct 2011 07:32:54 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.it; s=s1024; t=1318923174; bh=iQQJQTagJr9WHmR6N7LThYCKJUuIzwXH46EVGiopXik=; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=kzD825WUDGsQwYQwvRejF7haFwuq5Poxo6PgmtatzsPuF2E3VbCzJe9QZOyvk7ThsjKaDmeJKB/hSi49NxdQpa3tloT1DcGM7HJr2Qlok2+Jbc7kVc6BCa25Poxh86ZjaLfRxyMQP/zdQaP2P38mbahg7BicCoBnzHh7pnzKU4k= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.it; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=PNd9CI+SI83swGpdVKUVQwLKAtEdaFWa5qncOsnNrMhuRqBCm0qH1kTJQuCjModzrRmt65tzrf8ZTEFte5vlBRk+b2nGu+28nSDTQCinO8yGlo/LR2TeteZR2xKF9JLlMW8vtlof01YoX2Hw4CJrSN0td0Q1iIFGg8+AlHkApo8=; X-YMail-OSG: lS19bGMVM1nA6Ya522FOR2Lj4GmC2MKzTg1Vp4BiY3gn.DF rMaE_PVjdipQcsuItT9aSzuMxL2TYlMqluEjgNc7zrr_sUsdP94eAXtdfFxs b_9kaJPn7uIVEaxOSa8ZkI.F2BXrpuWNQ.Tovqa5S1mtcTZejFE9LOVwLDeU sjk_iq3s9D2wC0r8AeWsy2oQOLvrLUzuWVkUunWV1K31GfkGH.5CduGI37nG WCO.Kr_lGHMBMlGxSSRLHJQEcADwTqaJ8YfXJtYQtvtyPFEdz.LtsGtZtm.z S4Ae7Maa_nXMnZICQttthL5nayTLwKanITX3UfVoVeUNbBO7PetEY0mdyLXF fgxn7QafYb.PZ7.dLnPtJ8971W5yQDjrpcu.YcJ9ZR0xFae93NHJQBjEXuzb o_eQ- Received: from [85.33.62.89] by web29006.mail.ird.yahoo.com via HTTP; Tue, 18 Oct 2011 08:32:54 BST X-Mailer: YahooMailWebService/0.8.114.317681 References: <4E6DE18B.4010505@lab.ntt.co.jp> <4E7861C1.2000607@gmail.com> <4E8EC1D8.3080700@lab.ntt.co.jp> <4E9C6573.8050507@gmail.com> Message-ID: <1318923174.20848.YahooMailNeo@web29006.mail.ird.yahoo.com> Date: Tue, 18 Oct 2011 08:32:54 +0100 (BST) From: Leonardo Francalanci Reply-To: Leonardo Francalanci Subject: Re: WIP: Collecting statistics on CSV file data To: Shigeru Hanada , Etsuro Fujita Cc: "pgsql-hackers@postgresql.org" In-Reply-To: <4E9C6573.8050507@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.499 tagged_above=-5 required=5 tests=BAYES_05=-0.5, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201110/979 X-Sequence-Number: 196785 > New API AnalyzeForeignTable=0A=0A=0A=0AI didn't look at the patch, but I'= m using CSV foreign tables with named pipes=0Ato get near-realtime KPI calc= ulated by postgresql. Of course, pipes can be=0Aread just once, so I wouldn= 't want an "automatic analyze" of foreign tables...