7 ms·

Listen/notify is poised to become much better in PG 18 and 19

• stuartaxelowen 4mo ago
  Why’s that?
  • TkTech 4mo ago
    In pg19 https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=282b1cde9 https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit... will land, which significantly improves NOTIFY performance. Right now LISTEN/NOTIFY doesn't scale to very busy instances because a `NOTIFY` within a transaction takes a global lock.
    • ivanr 4mo ago
      More context: https://www.recall.ai/blog/postgres-listen-notify-does-not-scale https://www.recall.ai/blog/postgres-listen-notify-does-not-s...
    • doctorpangloss 4mo ago
      Well another POV is, AWS sells RDS instances capable of global lock NOTIFY. Clearly people have been using it despite it being really slow. It's a terrible architecture but does it matter? This article should really say "AWS is a useful but expensive way to run your apps," which isn't say much of anything at all.