From owner-freebsd-questions@FreeBSD.ORG Thu Jul 19 05:46:57 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id DDDA316A402 for ; Thu, 19 Jul 2007 05:46:57 +0000 (UTC) (envelope-from darek@nyi.net) Received: from m.nyi.net (m.nyi.net [66.111.12.250]) by mx1.freebsd.org (Postfix) with SMTP id 8023313C467 for ; Thu, 19 Jul 2007 05:46:57 +0000 (UTC) (envelope-from darek@nyi.net) Received: (qmail 48979 invoked by uid 89); 19 Jul 2007 05:20:15 -0000 Received: from unknown (HELO ?192.168.0.5?) (24.184.49.86) by 0 with SMTP; 19 Jul 2007 05:20:15 -0000 Message-ID: <469EF48C.2080109@nyi.net> Date: Thu, 19 Jul 2007 01:20:12 -0400 From: Darek M User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 To: Tek Bahadur Limbu References: <469A06D1.4030601@wlink.com.np> <20070717155834.GK46587@nemesis.frida.mouhaha.de> <469D1A7E.6030906@wlink.com.np> In-Reply-To: <469D1A7E.6030906@wlink.com.np> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: Oliver Peter , freebsd-questions@freebsd.org Subject: Re: Integrating Postfix + Amavisd-new + Clamav + DSpam + DBmail 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: Thu, 19 Jul 2007 05:46:57 -0000 Tek Bahadur Limbu wrote: > Since I am very new to database terminology, how scalable is a > database in terms of the data storage size. I mean suppose, we have > 20000 users each with a quota of 1 GB. What will eventually happen if > they all used up their quotas. That will be about 20 TB in size!! > > Thanking you... You should also consider that DSPAM, fully trained, can grow very large. I use a single username for a dozen email boxes, and the database is 3.5GB. Though you can trim it by dropping tokens that aren't as accurate, or aren't as frequently used, it could still become big, especially with a lot of users.