Clean build MINGW64 CreateProcessAsUserA could not be located

Hello, I have compiled postgres 11.11 using the following configuration without errors. # gcc --version gcc.exe (Rev6, Built by MSYS2 project) 10.2.0 ./configure --host=x86_64-w64-mingw32 --prefix=/c/postgresql/pg11/ --with-openssl --with-libxml make without errors make install without errors

Re: Batch update million records in prd DB

1) Don't pretend it is a left join when your where clause will turn it into an INNER join. LEFT JOIN pol gp ON gab.policy_id = gp.id WHERE *AND gp.name LIKE 'Mobile backup%' AND gp.deleted_at IS NOT NULL;* 2) It is interesting to me that the

Re: Code of Conduct: Russian Translation for Review

Hello, 27.02.2021 03:51, Stacey Haysler wrote: > The PostgreSQL Community Code of Conduct Committee has received a > draft of the Russian translation of the Code of Conduct Policy updated > August 18, 2020 for review. > > The English version of the Policy is at: >

Re: Batch update million records in prd DB

Hi Michael This is the script and explain plan info, please check, seems Filter remove more records took more time DO $MAIN$ DECLARE affect_count integer := 1000; processed_row_count integer := 0; BEGIN LOOP exit WHEN affect_count = 0; UPDATE app