Re: per-database logging

From: "scott" <scott(at)QNET(dot)COM>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "To: \"Ben Kim\"" <bkim(at)coe(dot)tamu(dot)edu>, "Cc:" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: per-database logging
Date: 2004-03-10 16:00:04
Message-ID: 000701c406b8$c1546820$46deddd1@scott
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Take me off your silly list or address book!
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ben Kim" <bkim(at)coe(dot)tamu(dot)edu>
Cc: <pgsql-admin(at)postgresql(dot)org>
Sent: Wednesday, March 10, 2004 7:08 AM
Subject: Re: [ADMIN] per-database logging

> Ben Kim <bkim(at)coe(dot)tamu(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Byrocat 2004-03-10 16:29:26 POrtability of ODBC and DBArtisan connection information
Previous Message Greg Spiegelberg 2004-03-10 15:51:50 Re: syslog slowing the database?