pg_background: Make Postgres do the long work (while your session stays light)

21 pointsposted 10 hours ago
by tanelpoder

2 Comments

pragmatic

8 hours ago

Every DBAs nightmare.

Please use this with caution. There’s a reason client task libraries exist and you aren’t using the most expensive hardware, central point of contention for this type of thing.

Under the right conditions this could be useful/interesting buuutt this is ripe for abuse.

tomrod

9 hours ago

Nice Idea. Recommendation: more docs! I could see individuals trying this out and having a hard time knowing how to kill the background process(es).