Postgres Pro
Downloads
Home   >   mailing lists

Re: WIP Patch: Use sortedness of CSV foreign tables for query planning - Mailing list pgsql-hackers

From Robert Haas
Subject Re: WIP Patch: Use sortedness of CSV foreign tables for query planning
Date
Msg-id CA+TgmoYBMi01y5sGE2HQCpR2PQwL1c6O2=GdyLgm5ptFrq98sw@mail.gmail.com
Whole thread Raw
In response to Re: WIP Patch: Use sortedness of CSV foreign tables for query planning  ("Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp>)
Responses Re: WIP Patch: Use sortedness of CSV foreign tables for query planning
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: WIP patch for LATERAL subqueries
Next
From: Robert Haas
Date:
Subject: Re: Windows Streaming replication -- Windows 2008 servers