> Yeah. As Andres pointed out somewhere or other, that also means you're > decoding the WAL once per user instead of just once. I'm surprised > that hasn't been cost-prohibitive.
We'd definitely prefer to have one subscription and do the decoding only once. But we haven't run into big perf issues with the current setup so far. We use it for non-blocking copying of shards (regular PG tables under the hood). Most of the time is usually spent in the initial copy phase, not the catchup. And also in practice our users often only have one table owning user (and more than 5 table owning users is extremely rare).