On Thu, Dec 19, 2024 at 02:28:21PM +0800, jian he wrote:
> Since materialized views have physical storage,
>
> we can make materialized views also using COPY table_name, instead of
> COPY(query).
>
> Some simple tests show around %3.7 or 4.3% speed up.
This restriction comes from 3bf3ab8c5636 as such relations may not be
scannable when they have no data, no? Perhaps this restriction could
be lifted, but I'd suggest to dig more into the lists, there should be
arguments and ideas explaining what could be done in this case
(spoiler: I did not look at that).
--
Michael