On Mar 23, 2004, at 11:16 AM, Subbiah, Stalin wrote:

And we also created rules to allow update, delete, and insert on those
views so that they looked like tables. The reason we did this is
because we ran into issues with too many open files during pg_dump when
we had thousands of tables instead of about 1 hundred tables and
thousands of views.

Is it because you had smaller value set for max. allowable number of open
files descriptor. what was ulimit -a set to ?

It was actually running on OS X and it was a shared memory issue. We would have had to recompile the Darwin kernel to get a bigger SHMMAX, but this solution seemed better since we would possibly be installing on servers where we wouldn't have that much leeway. I think that the view idea works better for a number of other reasons. For one, I can do a query on the base table and see all of the rows for all of the schemas at once, that has proven quite useful.

We, however, did have a need to periodically select data from 2 schemas
at a time, and it was simpler logic than if we needed 2 database

Adam Ruth

On Mar 22, 2004, at 2:30 PM, Subbiah, Stalin wrote:

--sorry to repost, just subscribed to the list. hopefully it gets to
list this time --

Hi All,

We are evaluating the options for having multiple databases vs.
schemas on a
single database cluster for a custom grown app that we developed. Each
installs same set of tables for each service. And the service could
be in thousands. so Is it better to have 1000 databases vs 1000
schemas in a
database cluster. What are the performance overhead of having multiple
databases vs. schemas (if any). I'm leaning towards having schemas
than databases but i would like to get others opinion on this.
your reply.


---------------------------(end of
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to