he
    dashboard created for salespeople.  A job could be scheduled to update
    the statistics each night using this SQL statement:

</P><PRE
CLASS="PROGRAMLISTING"
>REFRESH MATERIALIZED VIEW sales_summary;</PRE
><P></P
><P
>    Another use for a materialized view is to allow faster access to data
    brought across from a remote system, through a foreign data wrapper.
    A simple example using <TT
CLASS="LITERAL"
>file_fdw</TT
> is below, with timings,
    but since this is using cache on the local syst