walsender RAM increases by 500 MB while data is 80 MB
От | Avi Weinberg |
---|---|
Тема | walsender RAM increases by 500 MB while data is 80 MB |
Дата | |
Msg-id | DB9PR07MB71808AC6C7770AF2FB36B95BCB252@DB9PR07MB7180.eurprd07.prod.outlook.com обсуждение исходный текст |
Ответы |
Re: walsender RAM increases by 500 MB while data is 80 MB
|
Список | pgsql-general |
Hi Experts,
Your input is most welcome!
We are using Postgres 13 (and plan to upgrade to 15 soon). We have logical replication with about 40 servers subscribing to one publisher. 40 Walsender processes are running on the publisher server. When we insert a row into a table holding binary data the walsender RAM usage increases by 500MB although the row binary data is only 80MB. We see this increase in all walsender processes. At some point we got OOM and the process was killed.
- Why does the walsender increases by 500MB when the data change was only 80MB
- Is some of the 500MB increase due to shared memory or each walsender has its own 500MB increase. I assume that if it was only in shared memory we would not have gotten OOM…
- Why when logical_decoding_work_mem = 64MB the RAM is 15 times that size? Shouldn't any additional space be used from disk and not RAM?
- Will adding streaming = on to publication "PUBLICATION pub WITH (streaming = on)" can alleviate the issue?
- Are there configuration options that can resolve the RAM issue. It can be also in version 15 since we plan to upgrade soon.
Thanks!
В списке pgsql-general по дате отправления: