X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8E482D1B4DB for ; Wed, 10 Mar 2004 16:04:32 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 30962-04 for ; Wed, 10 Mar 2004 12:04:22 -0400 (AST) Received: from mx-i.qnet.com (mx-i.qnet.com [209.221.198.23]) by svr1.postgresql.org (Postfix) with ESMTP id F183FD1B4A7 for ; Wed, 10 Mar 2004 12:04:21 -0400 (AST) Received: from cello.qnet.com ([209.221.198.10]) by mx-i.qnet.com with esmtp (Exim 4.30) id 1B16Bu-000F8a-KK; Wed, 10 Mar 2004 08:04:18 -0800 Received: from scott (arc0-pool222-070.dial.qnet.com [209.221.222.70]) by cello.qnet.com (8.9.3/8.9.1) with SMTP id IAA29729; Wed, 10 Mar 2004 08:04:14 -0800 (PST) Message-ID: <000701c406b8$c1546820$46deddd1@scott> From: "scott" To: "Tom Lane" Cc: , "To: \"Ben Kim\"" , "Cc:" References: <6586.1078931284@sss.pgh.pa.us> Subject: Re: per-database logging Date: Wed, 10 Mar 2004 08:00:04 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/185 X-Sequence-Number: 12754 Take me off your silly list or address book! ----- Original Message ----- From: "Tom Lane" To: "Ben Kim" Cc: Sent: Wednesday, March 10, 2004 7:08 AM Subject: Re: [ADMIN] per-database logging > Ben Kim 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