Horton
Menu

Re: WIP Patch: Use sortedness of CSV foreign tables for query planning

Robert Haas <robertmhaas@gmail.com>

View thread
From: Robert Haas <robertmhaas@gmail.com>
To: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-08-06T12:48:06Z
Lists: pgsql-hackers 
On Sun, Aug 5, 2012 at 10:41 PM, Etsuro Fujita
<fujita.etsuro@lab.ntt.co.jp> wrote:
> I think file_fdw is useful for managing log files such as PG CSV logs.  Since
> often, such files are sorted by timestamp, I think the patch can improve the
> performance of log analysis, though I have to admit my demonstration was not
> realistic.

Hmm, I guess I could buy that as a plausible use case.

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