Speed up COPY into tables with DEFAULT nextval()
Simon Riggs <simon@2ndQuadrant.com>
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.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/copy.c | modified | +13 −2 |
| src/backend/optimizer/util/clauses.c | modified | +116 −0 |
| src/include/optimizer/clauses.h | modified | +1 −0 |