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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WIP Patch: Use sortedness of CSV foreign tables for query planning
Date: 2012-08-06 12:48:06
Message-ID: CA+TgmoYBMi01y5sGE2HQCpR2PQwL1c6O2=GdyLgm5ptFrq98sw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Aug 5, 2012 at 10:41 PM, Etsuro Fujita
<fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2012-08-06 12:50:02 Re: Windows Streaming replication -- Windows 2008 servers
Previous Message Robert Haas 2012-08-06 12:45:33 Re: WIP patch for LATERAL subqueries