https://github.com/authzed/spicedb/issues/1320 is the tracking issue for read-replica support for Postgres; without it, its basically how large you can scale your PG instance as stated above, which should be more than capable of ~millions of rows