From owner-freebsd-questions@FreeBSD.ORG  Sat May 30 16:50:49 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 D2D43106566C
	for <freebsd-questions@freebsd.org>;
	Sat, 30 May 2009 16:50:49 +0000 (UTC)
	(envelope-from mel.flynn+fbsd.questions@mailing.thruhere.net)
Received: from mailhub.rachie.is-a-geek.net (rachie.is-a-geek.net
	[66.230.99.27]) by mx1.freebsd.org (Postfix) with ESMTP id 9F9508FC20
	for <freebsd-questions@freebsd.org>;
	Sat, 30 May 2009 16:50:49 +0000 (UTC)
	(envelope-from mel.flynn+fbsd.questions@mailing.thruhere.net)
Received: from sarevok.dnr.servegame.org (mailhub.rachie.is-a-geek.net
	[192.168.2.11])
	by mailhub.rachie.is-a-geek.net (Postfix) with ESMTP id B16D87E837;
	Sat, 30 May 2009 08:50:48 -0800 (AKDT)
From: Mel Flynn <mel.flynn+fbsd.questions@mailing.thruhere.net>
To: freebsd-questions@freebsd.org
Date: Sat, 30 May 2009 18:50:46 +0200
User-Agent: KMail/1.11.3 (FreeBSD/8.0-CURRENT; KDE/4.2.3; i386; ; )
References: <1F9F36FCD9644D4683DADAF7DD62B412@john>
	<200905301753.38697.mel.flynn+fbsd.questions@mailing.thruhere.net>
	<alpine.BSF.2.00.0905301804050.18381@wojtek.tensor.gdynia.pl>
In-Reply-To: <alpine.BSF.2.00.0905301804050.18381@wojtek.tensor.gdynia.pl>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200905301850.47027.mel.flynn+fbsd.questions@mailing.thruhere.net>
Cc: Wojciech Puchar <wojtek@wojtek.tensor.gdynia.pl>,
	Johan Hendriks <Johan@double-l.nl>
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 <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 30 May 2009 16:50:50 -0000

On Saturday 30 May 2009 18:05:12 Wojciech Puchar wrote:
> > 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

Only for single machine installs as I wouldn't recommend sqlite over NFS to 
share the database.
The idea was to have one machine (or a replicated cluster) with a database and 
several mail servers getting their information from there. It's less about 
performance, more about a preference of how you want to manage your 
information.
-- 
Mel