• Distributed Polling with SKIP LOCKED
  1. https://www.evernote.com/client/web#?an=true&fs=true&n=93f6cdf2-633d-4051-8b99-7e2d05498ead&s=s173&
  2. https://gist.github.com/rponte/0c5b0e3c1b84c0c2e49c863215c2c0f4
  3. https://gist.github.com/rponte/5e8d41fd3b2ced22206dce788208c30b (Implementing, rewriting, and rebuilding a task queue - by @tef_ebooks)
  4. https://todd-hubers.medium.com/you-really-can-replace-kafka-with-a-database-9e82a7c248a6 (Replacing Kafka with a database?)
  5. https://www.cloudamqp.com/blog/2015-11-23-why-is-a-database-not-the-right-tool-for-a-queue-based-system.html
  6. https://viralpatel.net/blogs/oracle-skip-locked/
  7. https://vladmihalcea.com/database-job-queue-skip-locked/
  8. https://github.com/vladmihalcea/high-performance-java-persistence/blob/master/core/src/test/java/com/vladmihalcea/book/hpjp/hibernate/concurrency/SkipLockJobQueueTest.java#L186
  9. https://docs.jboss.org/hibernate/orm/5.2/userguide/html_single/Hibernate_User_Guide.html#locking-follow-on

Não use UUID como PK nas tabelas do seu banco de dados.

Have you ever needed to copy your indexes from one platform to another without restoring a backup?

Run this script on the source database. You have one option which is to force the background option.

var always_background = true;