Re: BUG: deadlock between autovacuum worker and client backend during removal of orphan temp tables with sequences

2024-04-02 Thread Michael Zhilin
Thanks to all for review, testing and commit!!! On 2 April 2024 22:04:54 GMT+03:00, Tom Lane wrote: >Akshat Jaimini writes: >> The code seems to implement the feature and has good and explanatory >> comments associated with it. >> I believe we can go ahead with committing patch although I wou

Re: When extended query protocol ends?

2024-02-22 Thread Michael Zhilin
too strict limitation. Terminating a sequence of extended messages with a Query message instead of a Sync message is definitely undefined behaviour. -- Michael Zhilin Postgres Professional +7(925)3366270 https://www.postgrespro.ru

Re: Shared detoast Datum proposal

2024-01-23 Thread Michael Zhilin
of jsonb probably can get benefits from this. the precondition is the toast value should be accessed 1+ times, including the jsonb_out function. I think this would be not rare to happen. -- Michael Zhilin Postgres Professional +7(925)3366270 https://www.postgrespro.ru

[PATCH] fix wait_event of pg_stat_activity in case of high amount of connections

2022-06-30 Thread Michael Zhilin
r allocation. In example above, the timing is reduced from 4.4ms to 1.5ms (3 times). The patch is for PostgreSQL version 15. If fix is OK and is required for previous versions, please let know. It's worth to mention Yury Sokolov as co-author of patch. Please feel free to ask a