Hi, as I posted already in the general newsgroup our company has decided that we would like to sponsor the implementation of materialized views for Postgres. However at the moment we have no idea about the complexity of the implementation and therefore what the cost would be. Since the point is already on the TODO List, are there already any (rough) estimates?
The TODO List reads: "Right now materialized views require the user to create triggers on the main table to keep the summary table current. SQL syntax should be able to manager the triggers and summary table automatically." And this is what we need. "A more sophisticated implementation would automatically retrieve from the summary table when the main table is referenced, if possible." If this means that e.g. a query would "know by itself" that it could get the data from the view instead of from the main table, then we don't need this feature at the moment. Otherwise: Could anyone explain? Regards, Jan -- Jan Strube www.deriva.de -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
