| From: | CaT <cat(at)zip(dot)com(dot)au> |
|---|---|
| To: | Anders Steinlein <anders(at)steinlein(dot)no> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Schema per user? |
| Date: | 2009-05-08 05:01:29 |
| Message-ID: | 20090508050129.GF5550@zip.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, May 07, 2009 at 09:45:30PM +0200, Anders Steinlein wrote:
> Has anyone done something like this, or is it simply A Bad Idea? How
> many schemas can a database contain, until one hits a (hard or soft)
> limit? Keep in mind that this is not a "regular" web-app with thousands
> of users, but more in the range of 500-1000 for the foreseeable future.
I'm doing something similarish for our blog server. We have a blog db and
a schema for each user. This was mainly for backup, restore and maintenance
reasons. Being able to take one dump of all the blogs and then selectively
rip them out by schema is nice.
Currently we're at 632 schemas and roles and climbing. No problems as yet.
--
"A search of his car uncovered pornography, a homemade sex aid, women's
stockings and a Jack Russell terrier."
- http://www.news.com.au/story/0%2C27574%2C24675808-421%2C00.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2009-05-08 06:24:20 | Re: getting a list of users |
| Previous Message | Scott Marlowe | 2009-05-08 04:51:07 | Re: Schema per user? |