Re: Shared detoast Datum proposal

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

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

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?

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

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

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

[PATCH] Avoid useless prefetches in case of recent FPI WAL records

971602+03 |    0 |   0 | 0 |    0 |    32818 |    65636 |    0 |  0 |    0     (1 row) i.e. there is no more useless fadvise() calls and amount of skipped repeated blocks are increased by amount of modified blocks. Please feel free to ask any questions! Than