Re: Question about VACUUM behavior with sub-transactions in stored procedures

2024-10-31 Thread Кириллов Вячеслав
Hello everyone, I'd like to revisit the topic of auto VACUUM's interaction with stored procedures that perform transactions, with a more technical clarification as suggested earlier. Let's consider the behavior of VACUUM and system table updates after transaction commits in procedures that freq

Re: Question about VACUUM behavior with sub-transactions in stored procedures

2024-10-31 Thread Кириллов Вячеслав
egards, Vyacheslav Kirillov От: David G. Johnston Отправлено: 21 октября 2024 г. 16:55 Кому: Кириллов Вячеслав Копия: pgsql-hack...@postgresql.org Тема: Re: Question about VACUUM behavior with sub-transactions in stored procedures On Monday, October 21, 2024,

Re: Question about VACUUM behavior with sub-transactions in stored procedures

2024-10-21 Thread David G. Johnston
On Monday, October 21, 2024, Кириллов Вячеслав wrote: > I have a question regarding the behavior of the auto VACUUM in PostgreSQL > in the context of using stored procedures with sub-transactions. > > This is a general usage inquiry not suited to discussion on -hackers. We have a -general mailin