pgsql: Speed up COPY into tables with DEFAULT nextval()

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Speed up COPY into tables with DEFAULT nextval()
Date: 2014-01-20 17:23:13
Message-ID: E1W5IZ7-0006Gu-O7@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Speed up COPY into tables with DEFAULT nextval()

Previously the presence of a nextval() prevented the
use of batch-mode COPY. This patch introduces a
special case just for nextval() functions. In future
we will introduce a general case solution for
labelling volatile functions as safe for use.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/4d1e2aeb1a162770683a8d1e13fc13ac2d95d810

Modified Files
--------------
src/backend/commands/copy.c | 15 ++++-
src/backend/optimizer/util/clauses.c | 116 ++++++++++++++++++++++++++++++++++
src/include/optimizer/clauses.h | 1 +
3 files changed, 130 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Fujii Masao 2014-01-20 17:25:51 pgsql: Fix typo in comment.
Previous Message Magnus Hagander 2014-01-19 16:14:13 pgsql: Remove support for native krb5 authentication