Hi 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. /kaare