On Sun, 29 Dec 2019 12:27:13 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Tatsuo Ishii <ishii@sraoss.co.jp> writes:
> >> here is an unexpected error found while testing IVM v11 patches
> >> ...
> >> ERROR: out of shared memory
>
> > I think we could avoid such an error in IVM by reusing a temp table in
> > a session or a transaction.
>
> I'm more than a little bit astonished that this proposed patch is
> creating temp tables at all. ISTM that that implies that it's
> being implemented at the wrong level of abstraction, and it will be
> full of security problems, as well as performance problems above
> and beyond the one described here.
We realized that there is also other problems in using temp tables
as pointed out in another thread. So, we are now working on rewrite
our patch not to use temp tables.
Regards,
Yugo Nagata
--
Yugo NAGATA <nagata@sraoss.co.jp>