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 3D98910C79 for ; Mon, 30 Sep 2013 09:23:33 +0000 (UTC) Received: (qmail 17739 invoked by uid 500); 30 Sep 2013 09:23:21 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 17574 invoked by uid 500); 30 Sep 2013 09:23:19 -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 17499 invoked by uid 99); 30 Sep 2013 09:23:16 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Sep 2013 09:23:16 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of bcitrin@gmail.com designates 209.85.192.175 as permitted sender) Received: from [209.85.192.175] (HELO mail-pd0-f175.google.com) (209.85.192.175) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Sep 2013 09:23:09 +0000 Received: by mail-pd0-f175.google.com with SMTP id q10so5374203pdj.6 for ; Mon, 30 Sep 2013 02:22:48 -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=Qn7X4oafK0O7ExJPGWNKX1psMuu4S8BrxM58k9jM55c=; b=c8hdF3DUaTZox4vowdZttrnyLIBPVyKiuTDzpoosfxshqHTHwosrL8eDXGtaWMnqAg XX9E2naMSJqs9CQLzmm/4e6WMA2wgv8bEfFWw3iMv6Z2X9Tedf3phA20ubunr3TAYKhj AUr6CREPNE3AugZjU5I4WsJjiLZe4ZXBhPHUOiIRJvUsRydigtd2RobPJImt+K5B8Qly lbUV6LiYZ2uQ6COJ0lvgC7oOtx3BY/KasBfRdpmtt38pYtfb3HqHIKF23VqqMFKF/X4F tTkbV54BgIZR12DJ75UEURKbtVOCaYu1NFw5UVNCqyC3+x4dggppwhi0En4cux96QFWg ruxg== MIME-Version: 1.0 X-Received: by 10.68.203.34 with SMTP id kn2mr22475606pbc.82.1380532968487; Mon, 30 Sep 2013 02:22:48 -0700 (PDT) Received: by 10.70.85.138 with HTTP; Mon, 30 Sep 2013 02:22:48 -0700 (PDT) Date: Mon, 30 Sep 2013 12:22:48 +0300 Message-ID: Subject: Cleanup of an online database From: Boaz Citrin To: user@couchdb.apache.org Content-Type: multipart/alternative; boundary=047d7b10c8513000b804e7966168 X-Virus-Checked: Checked by ClamAV on apache.org --047d7b10c8513000b804e7966168 Content-Type: text/plain; charset=ISO-8859-1 Hello, Having a database with massive writes and updates, its file (and views) get huge and fragmented. Even a daily compaction takes few hours, and we cannot allow pausing these updates as users count on latest information. So we need some kind of online cleanup... I wonder it we could somehow copy files to a side database, run compaction, replicate latest changes and swap databases. Can anyone recommend a procedure? Thanks! --047d7b10c8513000b804e7966168--