That said, having a million users is a bit strange. Do you want to give
each visitor to your website a unique Postgres role, or something like
that? I think this is unusual, but it should work.
OK, thanks for the feedback, all. It may not be necessary to have such a fine grained system, but I was just wondering.
the caches used to store contents of system catalogs. I think you
should test it out and see what happens. I haven't seen any published
_actual_ benchmarks on this point.
I will, if this progresses. I did want to know if something like this has been tried and failed before.