On 9/29/06, Just Someone <just.some@xxxxxxxxx> wrote:
I am using a similar solution, and I tested it with a test containing 20K+ different schemas. Postgres didn't show slowness at all even after the 20K (over 2 million total tables) were created. So I have feeling it can grow even more.
That's good to know we haven't really tested it against that many schema's, other then actually creating them to make sure there wasn't some sort of hard limit or bug no one had run into before. Performance with schema's is actually one thing I do like. A query for any one user is only hitting the data in the one schema, so users with large data sets don't impact the query performance of users with smaller data sets.
