Return-Path: X-Original-To: apmail-couchdb-user-archive@www.apache.org Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9F98310FE5 for ; Thu, 17 Oct 2013 20:58:52 +0000 (UTC) Received: (qmail 18599 invoked by uid 500); 17 Oct 2013 20:57:35 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 18510 invoked by uid 500); 17 Oct 2013 20:57:30 -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 17890 invoked by uid 99); 17 Oct 2013 20:57:25 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Oct 2013 20:57:25 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of bcitrin@gmail.com designates 209.85.192.172 as permitted sender) Received: from [209.85.192.172] (HELO mail-pd0-f172.google.com) (209.85.192.172) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Oct 2013 20:57:20 +0000 Received: by mail-pd0-f172.google.com with SMTP id z10so3428870pdj.31 for ; Thu, 17 Oct 2013 13:57:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=/pSclxfY0Fpayt2YSFXCQq4CIemgn1qBFkwqq1zQowE=; b=pHoTBzY22MKxpt/ww/+zQvDjFZVmVLsWHy/ScAiY9w6Q46kflna/uy6Dd4JV3549vA UgmlMwiWWCSi3ke5ba809Izc705QZcjqqqdJNMjzObYhT1ixKIovGxf3gazr2afQLvic kEyKXCYFi33UWgB1EJHmoTETNtDi+2hX1VjziTzkKFPiBZuGU8iuC0TpI6Me0aBcomBY fEch8PgBib7C3mq9suiNXoTD5NojlBdDfnafagQYMOOf7y14TuvkwuIvOmlvKlJ1SUT6 N5h9/o6TTADpjKWz6F4fpJF3baxYrofKwEXU+ucDWHL+Q41d5j2L9tT8R4sn9Eh+WD1o z4wg== MIME-Version: 1.0 X-Received: by 10.68.240.33 with SMTP id vx1mr7900749pbc.12.1382043420551; Thu, 17 Oct 2013 13:57:00 -0700 (PDT) Received: by 10.70.85.138 with HTTP; Thu, 17 Oct 2013 13:57:00 -0700 (PDT) Date: Thu, 17 Oct 2013 23:57:00 +0300 Message-ID: Subject: Finding the right value for compaction configuration parameters From: Boaz Citrin To: user@couchdb.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org Hello, Testing database compaction with various doc_buffer_size values I get completely different results. Documentation is fairly vague, so I wonder how to choose the right value; What parameters affect this - HD buffer size, average doc size, database size, fragmentation, etc... ?! Same goes for view compaction and keyvalue_buffer_size. (For me the the compaction with default values was many times slower than with the values that gave the faster compaction). Thanks!