Re: PostgreSQL users on webhosting

On Jan 5, 2005, at 9:49 AM, Alan Garrison wrote:
> Out of curiosity, what kind of performance hit (whether CPU, memory,
> disk activity) is incurred with having a lot of postmasters running in
> this kind of a setup versus one postmaster with lots of databases?  We
> typically run one postmaster for a lot of

You'd have to have separate shared buffers for each which would eat
away from the filesystem cache.   Not to mention overhead of having
many more PG's running (in terms of just processes htat need to be
managed and memory used by each). You'd also have to have the users
connect to PG on an alternate port and that may irritate some.

In a web hosting (multi-user) environment it may make more sense. but
you could also just give each user his own db and only allow sameuser
access to each db via pg_hba.conf.

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/