Incremental View Maintenance: ERROR: out of shared memory

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Incremental View Maintenance: ERROR: out of shared memory
Date: 2019-12-28 20:15:09
Message-ID: 1577564109604-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello
here is an unexpected error found while testing IVM v11 patches

create table b1 (id integer, x numeric(10,3));
create incremental materialized view mv1
as select id, count(*),sum(x) from b1 group by id;

do $$
declare
i integer;
begin
for i in 1..10000
loop
insert into b1 values (1,1);
end loop;
end;
$$
;

ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
CONTEXT: SQL statement "DROP TABLE pg_temp_3.pg_temp_66154"
SQL statement "insert into b1 values (1,1)"
PL/pgSQL function inline_code_block line 1 at SQL statement

Regards
PAscal

--
Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Pryzby 2019-12-28 21:09:53 Re: [PATCH v1] pg_ls_tmpdir to show directories
Previous Message Tom Lane 2019-12-28 19:52:32 TAP testing for psql's tab completion code