Commits : Individual Commit

  Analyzed 7 days ago based on code collected 7 days ago.

Commit ID a36088bcfae85eeeb55e85c3f06c61cb2f0621c6

Anon80 Contributor: Tom Lane Files Modified: 2
Date: 12-July-2012 at 20:26 Lines Added: 197
Repository: git://git.postgresql.org/git/postgresql.git master Lines Removed: 3
Commit Comment: Skip text->binary conversion of unnecessary columns in contrib/file_fdw.
When reading from a text- or CSV-format file in file_fdw, the datatype
input routines can consume a significant fraction of the runtime.
Often, the query does not need all the columns, so we can get a useful
speed boost by skipping I/O conversion for unnecessary columns.

To support this, add a "convert_selectively" option to the core COPY code.
This is undocumented and not accessible from SQL (for now, anyway).

Etsuro Fujita, reviewed by KaiGai Kohei
 

Changes by Language

Language Code Added Code Removed Comments Added Comment Removed Blanks Added Blanks Removed
  C 133 2 36 1 28 0

Changes by File

 
 
 

Creative Commons License Copyright © 2013 Black Duck Software, Inc. and its contributors, Some Rights Reserved. Unless otherwise marked, this work is licensed under a Creative Commons Attribution 3.0 Unported License . Ohloh ® and the Ohloh logo are trademarks of Black Duck Software, Inc. in the United States and/or other jurisdictions. All other trademarks are the property of their respective holders.