Feature request #8791
Support PostgreSQL materialized views
| 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
Associated revisions
postgres provider: support materialized view (implements #8791)
History
#1
Updated by Remi Cura about 11 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 11 years ago
- Resolution set to fixed
- Status changed from Open to Closed
implemented in 03a60d3
#3
Updated by Jürgen Fischer about 11 years ago
- Resolution changed from fixed to fixed/implemented