Hi Stephen. >>The mat view takes longer and longer to update because it runs the full >>query. What you really want to do is have a side-table that you update >>regularly with appropriate SQL to issue UPDATE statements for just the >>current day (or whatever).
If correct, i leave only last datas into "side-table" and syncronize only these datas in the materialized view. If i delete datas from the side-table (ex- truncate) during the next materialized view update they will be lost or remain intact? Thank you Francesco -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
