Hi,
On Fri, 17 Jan 2020 17:33:48 +0900
Yugo NAGATA wrote:
> On Sun, 29 Dec 2019 12:27:13 -0500
> Tom Lane wrote:
>
> > Tatsuo Ishii writes:
> > >> here is an unexpected error found while testing IVM v11 patches
> > >> ...
> > >> ERROR: out of shared memory
> >
> > > I think we could avoid s
On Sun, 29 Dec 2019 12:27:13 -0500
Tom Lane wrote:
> Tatsuo Ishii 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.
Tatsuo Ishii 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
> 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..1000
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..1
loop
