Re: per-database logging - Mailing list pgsql-admin

From Tom Lane
Subject Re: per-database logging
Date
Msg-id 6586.1078931284@sss.pgh.pa.us
Whole thread Raw
In response to Re: per-database logging  (Ben Kim <bkim@coe.tamu.edu>)
List pgsql-admin
Ben Kim <bkim@coe.tamu.edu> writes:
> Thanks. Is there a disadvantage of running separate postmaster compared to
> running one postmaster with multiple databases?

More resource consumption, since each postmaster needs its own
shared-memory area.  Also possibly confusion, since you have to remember
which port number to connect to for each database.

            regards, tom lane

pgsql-admin by date:

Previous
From: Ben Kim
Date:
Subject: Re: per-database logging
Next
From: Louie Kwan
Date:
Subject: EPOCH time vs PG timestamp