Re: Decoding speculative insert with toast leaks memory

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Decoding speculative insert with toast leaks memory
Дата
Msg-id CAH2-Wzmcr=6_=Nz0Z5atx27z=PO+6OWNjwSf6AjkHyuNkZ9c-A@mail.gmail.com
обсуждение исходный текст
Ответ на Decoding speculative insert with toast leaks memory  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
Ответы Re: Decoding speculative insert with toast leaks memory  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Wed, Mar 24, 2021 at 10:34 PM Ashutosh Bapat
<ashutosh.bapat.oss@gmail.com> wrote:
> Hi All,
> We saw OOM in a system where WAL sender consumed Gigabttes of memory
> which was never released. Upon investigation, we found out that there
> were many ReorderBufferToastHash memory contexts linked to
> ReorderBuffer context, together consuming gigs of memory. They were
> running INSERT ... ON CONFLICT .. among other things. A similar report
> at [1]

What is the relationship between this bug and commit 7259736a6e5,
dealt specifically with TOAST and speculative insertion resource
management issues within reorderbuffer.c? Amit?

-- 
Peter Geoghegan

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "houzj.fnst@fujitsu.com"
Дата:
Сообщение: RE: Skip partition tuple routing with constant partition key
Следующее
От: "houzj.fnst@fujitsu.com"
Дата:
Сообщение: RE: Fdw batch insert error out when set batch_size > 65535