From owner-freebsd-questions@FreeBSD.ORG Sat May 30 16:05:21 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 89A4B1065686 for ; Sat, 30 May 2009 16:05:21 +0000 (UTC) (envelope-from wojtek@wojtek.tensor.gdynia.pl) Received: from wojtek.tensor.gdynia.pl (wojtek.tensor.gdynia.pl [IPv6:2001:4070:101:2::1]) by mx1.freebsd.org (Postfix) with ESMTP id A87758FC0C for ; Sat, 30 May 2009 16:05:20 +0000 (UTC) (envelope-from wojtek@wojtek.tensor.gdynia.pl) Received: from wojtek.tensor.gdynia.pl (localhost [IPv6:::1]) by wojtek.tensor.gdynia.pl (8.14.3/8.14.3) with ESMTP id n4UG5Cin018808; Sat, 30 May 2009 18:05:12 +0200 (CEST) (envelope-from wojtek@wojtek.tensor.gdynia.pl) Received: from localhost (wojtek@localhost) by wojtek.tensor.gdynia.pl (8.14.3/8.14.3/Submit) with ESMTP id n4UG5CRh018805; Sat, 30 May 2009 18:05:12 +0200 (CEST) (envelope-from wojtek@wojtek.tensor.gdynia.pl) Date: Sat, 30 May 2009 18:05:12 +0200 (CEST) From: Wojciech Puchar To: Mel Flynn In-Reply-To: <200905301753.38697.mel.flynn+fbsd.questions@mailing.thruhere.net> Message-ID: References: <1F9F36FCD9644D4683DADAF7DD62B412@john> <200905292225.41654.mel.flynn+fbsd.questions@mailing.thruhere.net> <200905301753.38697.mel.flynn+fbsd.questions@mailing.thruhere.net> User-Agent: Alpine 2.00 (BSF 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: Johan Hendriks , freebsd-questions@freebsd.org Subject: Re: Stable Mail Server And Web Mail X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 30 May 2009 16:05:22 -0000 > Depends on your usage. I'd say for SMTP table lookups, MySQL can out perform > PostgreSQL, unless one uses persistent connections (postfix proxy-map to be on > topic). The reason for this is that the connection start up for MySQL has > lower overhead then for PostgreSQL. for just quick searching of keys isn't just berkeley DB or maybe sqlite the best. there will be no connecting at all. anyway sqlite is much more useful