projects / users / gsingh / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 7f7485a) | patch
Add support for REFRESH MATERIALIZED VIEW CONCURRENTLY.
authorKevin Grittner <kgrittn@postgresql.org>
Tue, 16 Jul 2013 17:55:44 +0000 (12:55 -0500)
committerKevin Grittner <kgrittn@postgresql.org>
Tue, 16 Jul 2013 17:55:44 +0000 (12:55 -0500)
commitcc1965a99bf87005f431804bbda0f723887a04d6
tree694801e2e7a34a1247ad7858b9c81ff16a90ac39tree
parent7f7485a0cde92aa4ba235a1ffe4dda0ca0b6cc9acommit | diff
Add support for REFRESH MATERIALIZED VIEW CONCURRENTLY.

This allows reads to continue without any blocking while a REFRESH
runs.  The new data appears atomically as part of transaction
commit.

Review questioned the Assert that a matview was not a system
relation.  This will be addressed separately.

Reviewed by Hitoshi Harada, Robert Haas, Andres Freund.
Merged after review with security patch f3ab5d4.
16 files changed:
doc/src/sgml/mvcc.sgml diff | blob | blame | history
doc/src/sgml/ref/refresh_materialized_view.sgml diff | blob | blame | history
src/backend/commands/cluster.c diff | blob | blame | history
src/backend/commands/matview.c diff | blob | blame | history
src/backend/commands/tablecmds.c diff | blob | blame | history
src/backend/executor/execMain.c diff | blob | blame | history
src/backend/executor/nodeModifyTable.c diff | blob | blame | history
src/backend/nodes/copyfuncs.c diff | blob | blame | history
src/backend/nodes/equalfuncs.c diff | blob | blame | history
src/backend/parser/gram.y diff | blob | blame | history
src/bin/psql/tab-complete.c diff | blob | blame | history
src/include/commands/cluster.h diff | blob | blame | history
src/include/commands/matview.h diff | blob | blame | history
src/include/nodes/parsenodes.h diff | blob | blame | history
src/test/regress/expected/matview.out diff | blob | blame | history
src/test/regress/sql/matview.sql diff | blob | blame | history
Postgres clone for personal branches