On 9/29/2013 8:21 AM, Eugene Ostrovsky wrote:
This works fine for a single database. But for different databases different
relations between permissions-groups-users are requested. E.g. different set of
permissions for “Manager” group or different group membership for a given user.
This doesn’
On 28 Září 2013, 21:30, Eugene Ostrovsky wrote:
> Thanks for the answer!
>
> About you questions:
> 1. Postgres 9.3
> 2. There are about 30-50 user connections. Actually Only 2 of databases
> are used intensively, others only in rare cases.
> 3. Hardware is AMD Phenom II X4 965, 8 Gb RAM, 2 SATA2
On 9/28/2013 11:29 AM, Tomas Vondra wrote:
There are probably some corner cases where this might improve the
performance, but in most cases it's going to be worse. Why are you
switching to multiple clusters?
For example consider that you'll probably have to use much smaller shared
buffers (which
On 28 Září 2013, 20:12, Eugene Ostrovsky wrote:
> Hello!
>
> I would like to find out what is the difference in hardware resources
> consuming between two solutions:
> 1. Several databases in the same postgresql cluster
> 2. Several clusters (one per each database) on the same host
>
> Currently I
