Re: BUG #13635: Interlocks at selection with array_agg

<?php
$connections = [];
for($i = 0; $i < 72; $i++){
    $connections[] = pg_connect("***", PGSQL_CONNECT_FORCE_NEW);
    pg_query("SET application_name = 'DB.Upgrade #{$i}'");
}

$chunk = 10000;

do{
    foreach($connections as $id => $connection){
        if(!pg_connection_busy($connection)) {
            if($result = pg_get_result($connection)){
                pg_free_result($result);
            }
            pg_send_query($connection, strtr('
                UPDATE phone p
                SET mailing_id = (
                    SELECT array_agg(mailing_id)
                    FROM message m
                    WHERE m.phone_id = p.phone_id
                )
                WHERE
                    p.phone_id BETWEEN :min AND :max
            ', [
                ':min' => $chunk,
                ':max' => $chunk+9999,
            ]));
            $chunk += 10000;
        }
    }
    usleep(100000);
}
while(true);