I've tried this, but we ran into high CPU usage while the task was being run, causing other queries to time out or be delayed.
Is there a way to send low priority updates that wont interfere with other requests?
Is there a way to send low priority updates that wont interfere with other requests?
But not out of the box or on something like RDS - then your best bet is to write a script or function that uses sleep or pg_sleep to wait between calls to the database - I tend to do it in the database itself by using `CREATE FUNCTION` to write it, but depending on your comfort with postgres it may be better to do it in a scripting language or shell script (as in the parent article using a background job)
> processes per-query