| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Klaudie Willis <Klaudie(dot)Willis(at)protonmail(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: When Update balloons memory |
| Date: | 2021-12-13 23:17:31 |
| Message-ID: | 189763.1639437451@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
Klaudie Willis <Klaudie(dot)Willis(at)protonmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyotaro Horiguchi | 2021-12-14 01:11:37 | Re: BUG #17327: Postgres server does not correctly emit error for max_slot_wal_keep_size being breached |
| Previous Message | Klaudie Willis | 2021-12-13 23:07:50 | Re: When Update balloons memory |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2021-12-13 23:31:19 | Re: Why can't I have a "language sql" anonymous block? |
| Previous Message | Klaudie Willis | 2021-12-13 23:07:50 | Re: When Update balloons memory |