DO $$
    DECLARE
        page int := 10000;
        min_id int; max_id int;
    BEGIN
        SELECT max(id),min(id) INTO max_id,min_id FROM products;
        FOR j IN min_id..max_id BY page LOOP
                UPDATE products SET listed_at = created_at WHERE id >= j AND id < j+page;
                RAISE INFO 'committing data from % to % at % max_id %, total done %', j,j+page,now(), max_id, ((j+page) / max_id * 100);
                COMMIT;
            END LOOP;
    END;
$$;