Re: using schema's for data separation

On 9/29/06, Just Someone <just.some@gmail.com> 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.