| From: | Kevin Grittner <kgrittn(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Add support for REFRESH MATERIALIZED VIEW CONCURRENTLY. |
| Date: | 2013-07-16 18:29:58 |
| Message-ID: | E1UzA0c-0007ir-J7@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
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.
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/cc1965a99bf87005f431804bbda0f723887a04d6
Modified Files
--------------
doc/src/sgml/mvcc.sgml | 3 +-
doc/src/sgml/ref/refresh_materialized_view.sgml | 34 +-
src/backend/commands/cluster.c | 27 +-
src/backend/commands/matview.c | 524 +++++++++++++++++++++--
src/backend/commands/tablecmds.c | 3 +-
src/backend/executor/execMain.c | 10 +-
src/backend/executor/nodeModifyTable.c | 5 +-
src/backend/nodes/copyfuncs.c | 1 +
src/backend/nodes/equalfuncs.c | 1 +
src/backend/parser/gram.y | 7 +-
src/bin/psql/tab-complete.c | 17 +
src/include/commands/cluster.h | 3 +-
src/include/commands/matview.h | 2 +
src/include/nodes/parsenodes.h | 1 +
src/test/regress/expected/matview.out | 38 +-
src/test/regress/sql/matview.sql | 29 +-
16 files changed, 646 insertions(+), 59 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2013-07-16 23:18:12 | pgsql: Add --progress option to show progress report |
| Previous Message | David Fetter | 2013-07-16 17:41:44 | Re: SSL renegotiation |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Soroosh Sardari | 2013-07-16 18:37:28 | Re: A general Q about index |
| Previous Message | Greg Smith | 2013-07-16 18:17:25 | Re: Improvement of checkpoint IO scheduler for stable transaction responses |