Fun fact for people whose scaling plan anticipates moving from Postgres to CRDB:
SELECT FOR UPDATE SKIP LOCKED works great for turning Postgres into a job queue. It does not work the same way on CRDB and you will likely have to rewrite those queries or use an external job queue.
Comments
Fun fact for people whose scaling plan anticipates moving from Postgres to CRDB:
SELECT FOR UPDATE SKIP LOCKED works great for turning Postgres into a job queue. It does not work the same way on CRDB and you will likely have to rewrite those queries or use an external job queue.