Feature request #8791

Support PostgreSQL materialized views

Added by Augustin Roche about 7 years ago. Updated about 7 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Data Provider/PostGIS
Pull Request or Patch supplied:No Resolution:fixed/implemented
Easy fix?:No Copied to github as #:17493

Description

PostgreSQL now supports materialized views since version 9.3: (http://www.postgresql.org/docs/9.3/static/sql-creatematerializedview.html). This can be useful to cache the result of heavy geoprocessing queries, and QGIS should give direct access to them.
The workaround I use presently is to make a proxy normal view that queries the materialized view, in order to have it listed in QGIS.


Related issues

Related to QGIS Application - Feature request #9127: DBManager should show Postgres materialized views Closed 2013-11-26
Related to QGIS Application - Bug report #9135: PostGIS - materialized views only show if "also list tabl... Closed 2013-11-27
Related to QGIS Application - Bug report #9136: Browser does not show Postgres materialized views Closed 2013-11-27

Associated revisions

Revision 03a60d3b
Added by Jürgen Fischer about 7 years ago

postgres provider: support materialized view (implements #8791)

History

#1 Updated by Remi Cura about 7 years ago

++ :

It is a very important feature for qgis for all computation heavy queries.

Cheers,

Rémi-C

#2 Updated by Jürgen Fischer about 7 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed

implemented in 03a60d3

#3 Updated by Jürgen Fischer about 7 years ago

  • Resolution changed from fixed to fixed/implemented

Also available in: Atom PDF