The key features used here for PG seems SKIP LOCKED, and the PG notification system, which informs all clients that are directly connected to the database that

The key features used here for PG seems SKIP LOCKED, and the PG notification system, which informs all clients that are directly connected to the database that "this table has changed" so that they can restart their work. The notification system comes with a cost. You can't scale up the number of connection to a PG database instance. Therefore you need to go pooling. And for SKIP LOCKED, I just checked and mysql/maria do have it.