Re: transaction blocking on COMMIT

2021-05-27 Thread Bob Jolliffe
No brtfs. We are going to try turning off synchronous_commit temporarily to see if there are underlying I/O issues. On Mon, 24 May 2021 at 22:59, Alexey M Boltenkov wrote: > > On 05/24/21 19:24, Christophe Pettus wrote: > > > >> On May 24, 2021, at 09:22, Bob Jolliffe wrote: > >> > >> It is har

Count (select 1) subquery as constant

2021-05-27 Thread Eugen Konkov
Hello Pgsql-performance, To not flood network with many parameters I send only one and use `WITH` hack to reuse value inside query: WITH _app_period AS ( select app_period() ), ready AS ( SELECT min( lower( o.app_period ) ) OVER ( PARTITION BY agreement_id ) <@ (select * from _app_period) AS