Re: When Update balloons memory - Mailing list pgsql-general

From Tom Lane
Subject Re: When Update balloons memory
Date
Msg-id 189763.1639437451@sss.pgh.pa.us
Whole thread Raw
In response to Re: When Update balloons memory  (Klaudie Willis <Klaudie.Willis@protonmail.com>)
Responses Re: When Update balloons memory
List pgsql-general
Klaudie Willis <Klaudie.Willis@protonmail.com> writes:
> So, it seems like the index is central cog here:
>> create index ind1 on alpha ((deltatime::date));
> where "alpha" is a partition tableset partitioned by (deltatime::date)
> The general and simple updates like:
>> update alphatable set gamma=gamma || "#postfix#"
> makes the process memory balloon to the point of OOM.

That seems like a bug, but please supply a self-contained test case
rather than expecting other people to reverse-engineer one.

            regards, tom lane



pgsql-general by date:

Previous
From: Klaudie Willis
Date:
Subject: Re: When Update balloons memory
Next
From: Adrian Klaver
Date:
Subject: Re: Why can't I have a "language sql" anonymous block?