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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
Cc: legrand_legrand(at)hotmail(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Incremental View Maintenance: ERROR: out of shared memory
Date: 2019-12-29 17:27:13
Message-ID: 29014.1577640433@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2019-12-29 17:42:36 Re: TAP testing for psql's tab completion code
Previous Message Tom Lane 2019-12-29 17:13:42 Re: TAP testing for psql's tab completion code