A couple of quick questions about Postgres Materialized Views--searched,
but found very little:
I've got a few values that are fairly expensive to calculate, so I'd like
to pre-calculate the results. It's fine if the the data is stale for a few
hours, so I'd like to use Postgres Materialized Views:
1) How do I create a Materialized View using SQLAlchemy?
I checked the docs, and all I could find is how to reflect an
already-created materialized view. All my other DDL is managed by
SQLAlchemy in my app, so for simplicity I'd rather handle the materialized
view definition using SQLAlchemy as well.
2) How do I query this materialized view?
3) Is there a special method for refreshing?
Or should I just do *db.engine.execute("REFRESH MATERIALIZED VIEW view_name
CONCURRENTLY") *?
Cheers,
Jeff
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
