Return-Path: Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: (qmail 2185 invoked from network); 1 Feb 2010 16:53:49 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 1 Feb 2010 16:53:49 -0000 Received: (qmail 53597 invoked by uid 500); 1 Feb 2010 16:53:47 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 53515 invoked by uid 500); 1 Feb 2010 16:53:47 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 53505 invoked by uid 99); 1 Feb 2010 16:53:47 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Feb 2010 16:53:47 +0000 X-ASF-Spam-Status: No, hits=1.5 required=10.0 tests=SPF_PASS,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of santisaez@woop.es designates 82.194.80.181 as permitted sender) Received: from [82.194.80.181] (HELO relayout03-q02.dns-servicios.com) (82.194.80.181) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Feb 2010 16:53:36 +0000 Received: from relayout03-redir.dns-servicios.com (relayout03-redir.dns-servicios.com [82.194.80.185]) by relayout03.dns-servicios.com (Postfix) with ESMTP id 3EEF2769936 for ; Mon, 1 Feb 2010 17:53:12 +0100 (CET) Received: from vlc-187.dns-servicios.com (unknown [82.194.84.53]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by relayout03-dsp.dns-servicios.com (Postfix) with ESMTPS id 27E1E61AF6D for ; Mon, 1 Feb 2010 17:52:51 +0100 (CET) Received: (qmail 28064 invoked from network); 1 Feb 2010 17:52:52 +0100 Received: from ip85.dominioabsoluto.com (HELO macmini.local) (217.116.1.84) by 82.194.84-53.customers.hostalia.com with SMTP; 1 Feb 2010 17:52:52 +0100 Message-ID: <4B6706E4.4060603@woop.es> Date: Mon, 01 Feb 2010 17:52:52 +0100 From: Santi Saez User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.4; es-ES; rv:1.9.1.7) Gecko/20100111 Thunderbird/3.0.1 MIME-Version: 1.0 To: user@couchdb.apache.org Subject: Re: Best way to store 2^32 IPs in CouchDB References: <4B6700EB.7030906@woop.es> <46aeb24f1002010831r1fbdc4e6te0bbb00980fa19a@mail.gmail.com> In-Reply-To: <46aeb24f1002010831r1fbdc4e6te0bbb00980fa19a@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-RelayOut-Information: AntiSPAM and AntiVIRUS on relayout03 X-RelayOut-MsgID: 27E1E61AF6D.00000 X-RelayOut-SpamCheck: no es spam, SpamAssassin (no almacenado, puntaje=1.499, requerido 6.5, RDNS_NONE 0.00, WEIRD_PORT 1.50) X-RelayOut-SpamScore: s X-RelayOut-From: santisaez@woop.es X-RelayOut-Watermark: 1265647971.73146@kIXNARo07Uitwg4FPXd61g X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Status: No El 01/02/10 17:31, Robert Newson escribi�: > Try database compaction? I have tried database compaction in another testing server (Debian Lenny box) using CouchDB 0.8.0-2, and after database compaction disk size is the same: # curl http://localhost:5984/test {"db_name":"test","doc_count":15999,"doc_del_count":0,"update_seq":15999,"compact_running":false,"disk_size":60330312} # curl -X POST http://localhost:5984/test/_compact {"ok":true} # curl http://localhost:5984/test {"db_name":"test","doc_count":15999,"doc_del_count":0,"update_seq":15999,"compact_running":false,"disk_size":60330312} Acording to the documentation [1]: "Compaction rewrites the database file, removing outdated document revisions and deleted documents". So, it's normal because in my test I have not delete/upadate any document, only inserts. Thanks! [1] http://wiki.apache.org/couchdb/Compaction -- Santi Saez http://woop.es