Re: When Update balloons memory

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: When Update balloons memory
Дата
Msg-id 189763.1639437451@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: When Update balloons memory  (Klaudie Willis <Klaudie.Willis@protonmail.com>)
Ответы Re: When Update balloons memory
Список 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 по дате отправления:

Предыдущее
От: Klaudie Willis
Дата:
Сообщение: Re: When Update balloons memory
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Why can't I have a "language sql" anonymous block?