Re: Incremental View Maintenance: ERROR: out of shared memory

Hi,

On Fri, 17 Jan 2020 17:33:48 +0900
Yugo NAGATA <nagata@sraoss.co.jp> wrote:

> 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.

We fixed this problem in latest patches (v14) in the following thread.
https://www.postgresql.org/message-id/20200227150649.101ef342d0e7d7abee320159@sraoss.co.jp

We would appreciate it if you could review this.


Best Regards,

Takuma Hoshiai


> Regards,
> Yugo Nagata
> 
> 
> -- 
> Yugo NAGATA <nagata@sraoss.co.jp>
> 
> 
> 


-- 
Takuma Hoshiai <hoshiai@sraoss.co.jp>