Comment

Comment on Well, shit.

whats_a_lemmy@midwest.social ⁨1⁩ ⁨month⁩ ago

If you want a helper table you can just insert directly, no need for the cursor loop.

Sort:hotnew top

bacon_pdp@lemmy.world ⁨1⁩ ⁨month⁩ ago
[deleted]
source
- whats_a_lemmy@midwest.social ⁨1⁩ ⁨month⁩ ago
  At least in PG, that is explicitly not the case, unless I’m misunderstanding:
  
  Similarly, a PL/pgSQL loop of the form FOR x IN query LOOP … END LOOP will never use a parallel plan, because the parallel query system is unable to verify that the code in the loop is safe to execute while parallel query is active.
  
  postgresql.org/…/when-can-parallel-query-be-used.…
  
  At any rate, I feel like it’s questionable design to have a user making row-by-row decisions on hard deletes.
  
  source