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

From Kevin Grittner
Subject Re: WIP Patch: Use sortedness of CSV foreign tables for query planning
Date
Msg-id 501A64750200002500049353@gw.wicourts.gov
Whole thread Raw
In response to 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
"Etsuro Fujita" <fujita.etsuro@lab.ntt.co.jp> wrote:
> I would like to propose single-column sortedness options and
> insert appropriate pathkeys into the ForeignPath node based on
> these information:
> 
>  sorted: Boolean option to specify whether data file is sorted by
>      a column.
>  key: Specifies the name of a column by which data file is sorted.
>      Required when the above option is set to true.
>  direction: Specifies the sort order: asc or desc.  The default is
>      asc.
>  nulls: Specifies that nulls sort before or after non-nulls: first
>      or last.  first is the default when direction option is set
>      desc.  When direction option is not set desc, last is the
>      default.
For character-based columns, don't we need to know the collation?
-Kevin


pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: avoid unnecessary failure to open restored WAL files
Next
From: Josh Berkus
Date:
Subject: Re: Help me develop new commit_delay advice