database - 延迟或等待声明

Question

我有一个 500,000 行的 SQL 脚本:

UPDATE users SET region_id = 9814746 WHERE id = 101 AND region_id IS null;
UPDATE users SET region_id = 9814731 WHERE id = 102 AND region_id IS null;
UPDATE users SET region_id = 3470676 WHERE id = 103 AND region_id IS null;

我想每 50 行插入 10 秒的延迟。 pgsql 有没有像t-sql 这样的waitfor 语句。

谢谢。

Answer 1

Does pgsql have a waitfor statement like t-sql.

是的，pg_sleep :

pg=> SELECT pg_sleep(10);
 pg_sleep 
----------

(1 row)