git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: ad3ae64) | patch
Optimize update of tables with generated columns
2020年2月17日 14:19:58 +0000 (15:19 +0100)
2020年2月17日 14:20:58 +0000 (15:20 +0100)
commit c6679e4fca21d253ced84c51ac1a31c1b2aec72f
Optimize update of tables with generated columns

When updating a table row with generated columns, only recompute those
generated columns whose base columns have changed in this update and
keep the rest unchanged. This can result in a significant performance
benefit. The required information was already kept in
RangeTblEntry.extraUpdatedCols; we just have to make use of it.

Reviewed-by: Pavel Stehule <pavel.stehule@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/b05e781a-fa16-6b52-6738-761181204567@2ndquadrant.com
src/backend/commands/copy.c diff | blob | blame | history
src/backend/executor/execReplication.c diff | blob | blame | history
src/backend/executor/nodeModifyTable.c diff | blob | blame | history
src/include/executor/nodeModifyTable.h diff | blob | blame | history
src/include/nodes/execnodes.h diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /