From: | Mike Ivanov <mikei(at)activestate(dot)com> |
---|---|
To: | Greg Stark <gsstark(at)mit(dot)edu> |
Cc: | fabio(dot)lafarcioli(at)molinoalimonti(dot)com, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Number of tables |
Date: | 2009-09-01 01:10:39 |
Message-ID: | 4A9C748F.6030900@activestate.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Greg Stark wrote:
> You may
> not expect to be need to run queries which combine multiple users'
> data now but you will eventually.
>
We store cross-user data in a separate schema, which solves all *our*
problems.
> This doesn't work so great when each user is going to be specifying
> their own custom schema on the fly
This works fine, at least we didn't encounter any issues with that.
> but that's not really what
> relational databases were designed for.
Sometimes you have to.. you know, unusual things to meet some specific
requirements, like independent user schemas. It's not a conventional web
app we run :-)
I'm not arguing this is a bit extremal approach, but if one is forced to
go this path, it's quite walkable ;-)
Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2009-09-01 02:59:41 | Re: BUG #4919: CREATE USER command slows down system performance |
Previous Message | Greg Stark | 2009-09-01 01:01:26 | Re: Number of tables |