4 ms·

I've simply been using MySQL/Maria everywhere and am meaning to switch, but I'm not sure what makes Postgres this much better. Can this hack not be achieved by

I've simply been using MySQL/Maria everywhere and am meaning to switch, but I'm not sure what makes Postgres this much better. Can this hack not be achieved by a mariadb table too?

z92 7y ago
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.