Hi, On Fri, 17 Jan 2020 17:33:48 +0900 Yugo NAGATA <nag...@sraoss.co.jp> wrote:
> On Sun, 29 Dec 2019 12:27:13 -0500 > Tom Lane <t...@sss.pgh.pa.us> wrote: > > > Tatsuo Ishii <is...@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. We fixed this problem in latest patches (v14) in the following thread. https://www.postgresql.org/message-id/20200227150649.101ef342d0e7d7abee320...@sraoss.co.jp We would appreciate it if you could review this. Best Regards, Takuma Hoshiai > Regards, > Yugo Nagata > > > -- > Yugo NAGATA <nag...@sraoss.co.jp> > > > -- Takuma Hoshiai <hosh...@sraoss.co.jp>