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

From scott
Subject Re: per-database logging
Date
Msg-id 000701c406b8$c1546820$46deddd1@scott
Whole thread Raw
In response to Re: per-database logging  (Ben Kim <bkim@coe.tamu.edu>)
List pgsql-admin
Take me off your silly list or address book!
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Ben Kim" <bkim@coe.tamu.edu>
Cc: <pgsql-admin@postgresql.org>
Sent: Wednesday, March 10, 2004 7:08 AM
Subject: Re: [ADMIN] per-database logging


> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend


pgsql-admin by date:

Previous
From: Louie Kwan
Date:
Subject: EPOCH time vs PG timestamp
Next
From: Greg Spiegelberg
Date:
Subject: Re: syslog slowing the database?