I'd like to find out if there is a way that a datasource in MapServer can be a materialized view, this is due to the presence of indexes, these cannot be in views but only in materialized view - however, I seem to have trouble having MapServer accept materialized view as a datasource.

  • What kind of index would you need? If table has a spatial index it should work transparently also for simple views created like select geometry, attr from table where .... Materialized views should work as well. You must give more details about what you've done and what fails.
    – user30184
    Commented Jan 13, 2017 at 11:44
  • 1
    I have MapServer working against a standard view on PostgreSQL 9.2 to give WMS and WFS so I'm guessing the answer here should be yes.
    – nmtoken
    Commented Feb 11, 2017 at 16:56

1 Answer 1


Yes mapserver works with materialized view, configuration should be provided like for a simple Postgis relation. Example of layer configuration can be found in documentation:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.