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
