Re: WIP: Collecting statistics on CSV file data

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com>
Cc: Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: WIP: Collecting statistics on CSV file data
Date: 2011-11-18 15:54:40
Message-ID: CA+TgmoYVsh3eawS_j7Oj+1vO_oM7qC3vNh9YsWZk2NS6G19BNQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2011/11/18 Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)com>:
> - 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.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2011-11-18 16:09:57 pgsql: Avoid marking buffer dirty when VACUUM has no work to do.
Previous Message Tom Lane 2011-11-18 15:33:13 Re: range_adjacent and discrete ranges