pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Shigeru HANADA <shigeru.hanada@gmail.com>
Cc: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Cc: pgsql-hackers@postgresql.org
Subject: Re: WIP: Collecting statistics on CSV file data
Date: Fri, 06 Apr 2012 15:19:51 -0400
Message-ID: <12199.1333739991@sss.pgh.pa.us> (raw)
In-Reply-To: <4F7E57D9.3000807@gmail.com>
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>
	<4EC9CBC5.3070500@lab.ntt.co.jp>
	<4EE1FC38.5080707@lab.ntt.co.jp>
	<4EE5D862.1080809@gmail.com>
	<4EE74C5F.3000309@lab.ntt.co.jp>
	<4F7D8BBF.4050004@gmail.com>
	<4F7E57D9.3000807@gmail.com>

Shigeru HANADA <shigeru.hanada@gmail.com> writes:
> Just after my post, Fujita-san posted another v7 patch[1], so I merged
> v7 patches into v8 patch.

I've committed a modified version of this, but right after pushing it
I had a better idea about what the AnalyzeForeignTable API should do.
An issue that I'd not previously figured out is how analysis of an
inheritance tree could deal with foreign-table members, because it wants
to estimate the members' sizes before collecting the actual sample rows.
However, given that we've got the work split into a precheck phase and
a sample collection phase, that's not hard to solve: we could insist
that the FDW give back a size estimate in the precheck phase not the
sample collection phase.  I'm off to fix that up ...

			regards, tom lane

view thread (35+ messages)  latest in thread

Message-ID: <12199.1333739991@sss.pgh.pa.us>
Permalink:  ../12199.1333739991@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/12199.1333739991@sss.pgh.pa.us

copy link · copy postgr.es

reply

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: tgl@sss.pgh.pa.us, shigeru.hanada@gmail.com, fujita.etsuro@lab.ntt.co.jp
  Subject: Re: WIP: Collecting statistics on CSV file data
  In-Reply-To: <12199.1333739991@sss.pgh.pa.us>

* 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