Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 85AE76C6896 for ; Sun, 20 Nov 2011 23:51:29 -0400 (AST) Received: from tama500.ecl.ntt.co.jp ([129.60.39.148]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RSKum-0007lx-UP for pgsql-hackers@postgresql.org; Mon, 21 Nov 2011 03:51:29 +0000 Received: from mfs6.rdh.ecl.ntt.co.jp (mfs6.rdh.ecl.ntt.co.jp [129.60.39.149]) by tama500.ecl.ntt.co.jp (8.14.5/8.14.5) with ESMTP id pAL3pE1E020399; Mon, 21 Nov 2011 12:51:14 +0900 (JST) Received: from mfs6.rdh.ecl.ntt.co.jp (localhost [127.0.0.1]) by mfs6.rdh.ecl.ntt.co.jp (Postfix) with ESMTP id 1034A65F1; Mon, 21 Nov 2011 12:51:14 +0900 (JST) Received: from dmailsv1.y.ecl.ntt.co.jp (dmailsv1.y.ecl.ntt.co.jp [129.60.53.14]) by mfs6.rdh.ecl.ntt.co.jp (Postfix) with ESMTP id 0A45B65EB; Mon, 21 Nov 2011 12:51:14 +0900 (JST) Received: from mailsv01.y.ecl.ntt.co.jp by dmailsv1.y.ecl.ntt.co.jp (8.14.4/dmailsv1-2.1) with ESMTP id pAL3pD4U027316; Mon, 21 Nov 2011 12:51:13 +0900 (JST) Received: from localhost by mailsv01.y.ecl.ntt.co.jp (8.14.5/Lab-1.9) with ESMTP id pAL3pDKP029878; Mon, 21 Nov 2011 12:51:13 +0900 (JST) Message-ID: <4EC9CCC6.4030906@lab.ntt.co.jp> Date: Mon, 21 Nov 2011 13:00:06 +0900 From: Etsuro Fujita 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: Robert Haas CC: Shigeru Hanada , 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> <4E9FF04B.3050504@lab.ntt.co.jp> <4EB7C07A.5030205@gmail.com> <4EC60883.2050905@lab.ntt.co.jp> <4EC648CA.5050904@gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 201111/1214 X-Sequence-Number: 198699 (2011/11/19 0:54), Robert Haas wrote: > 2011/11/18 Shigeru Hanada: >> - I couldn't see the reason why file_fdw sets ctid of sample tuples, >> though I guess it's for Vitter's random sampling algorithm. If every >> FDW must set valid ctid to sample tuples, it should be mentioned in >> document of AnalyzeForeignTable. Exporting some functions from >> analyze.c relates this issue? > > If every FDW must set valid ctid to sample tuples, it should be fixed > so that they don't have to, I would think. It's for neither Vitter's algorithm nor exporting functions from analyze.c. It's for "foreign index scan" on CSV file data that I plan to propose in the next CF. So, it is meaningless for now. I'm sorry. I will fix it at the next version of the patch so that they don't have to. Best regards, Etsuro Fujita