Return-Path: X-Original-To: apmail-lucene-solr-user-archive@minotaur.apache.org Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E1A3118858 for ; Wed, 23 Sep 2015 14:08:32 +0000 (UTC) Received: (qmail 71094 invoked by uid 500); 23 Sep 2015 14:08:28 -0000 Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org Received: (qmail 71021 invoked by uid 500); 23 Sep 2015 14:08:28 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 71009 invoked by uid 99); 23 Sep 2015 14:08:28 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Sep 2015 14:08:28 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 8D82A180D2A for ; Wed, 23 Sep 2015 14:08:27 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.9 X-Spam-Level: *** X-Spam-Status: No, score=3.9 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=3, KAM_INFOUSMEBIZ=0.75, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id B4clfR56FCrY for ; Wed, 23 Sep 2015 14:08:17 +0000 (UTC) Received: from mail-oi0-f54.google.com (mail-oi0-f54.google.com [209.85.218.54]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 6041E44189 for ; Wed, 23 Sep 2015 14:08:17 +0000 (UTC) Received: by oibi136 with SMTP id i136so24290962oib.3 for ; Wed, 23 Sep 2015 07:08:17 -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=1SDzuid055xOlTOSsG6xCq93DLP6+Knco6F31h8qT+8=; b=UthkBQOWjPC68tcmLcv/mCjH1d5AnlCIJuVmttAg49IMq8gITkRtaB+1MdmPySM5eO GUYnYgc4BQd1lLS3ikDyC9wlkqXy5WhzxozdurO+B3FwOqdkT/IPjkJbp2MoKCC4eolu lWyKCXLlY9z0kMW7vUG2c+uB2GZu6aL5aZ8p/zxJjpb+ekc8TgEz1BV2tMkR/avN9QEi 12BnwjJCwnX8RtX99tO6J4+sR4TmPDGSE4VeI2F7G9myv/quyiiRiy1K8qVYkjc/s2SW 2hX3M1q532cyyqRlvCeZhSnvu975n0lXRj4e9uutzy8m0peyo8fcAndpKuehXSZSUnXM MZuA== MIME-Version: 1.0 X-Received: by 10.202.11.72 with SMTP id 69mr8889494oil.110.1443017296954; Wed, 23 Sep 2015 07:08:16 -0700 (PDT) Received: by 10.202.75.76 with HTTP; Wed, 23 Sep 2015 07:08:16 -0700 (PDT) Date: Wed, 23 Sep 2015 15:08:16 +0100 Message-ID: Subject: Risk of Over Sharding From: Alessandro Benedetti To: "solr-user@lucene.apache.org" Content-Type: multipart/alternative; boundary=001a113d17b863cac105206aa5b8 --001a113d17b863cac105206aa5b8 Content-Type: text/plain; charset=UTF-8 It's quite common to hear about the benefit of sharding. Until we reach the I/O bound on our machines, sharding is likely to reduce the query time. Furthermore working on smaller indexes will make the single searches faster on the smaller nodes. But what about the other way around ? What if we actually shard much more than needed ? Are we going to see also an increase in the query time ( due to the overhead of query distribution and aggregation of results ? ) Example : 100.000.000 docs across 16 shards . Wouldn't be more effective to have 4 or 8 shards maximum ? I suspect that prototyping is the right answer, but do we have any general suggestions strongly motivated ? Any resource to study ? Cheers -- -------------------------- Benedetti Alessandro Visiting card - http://about.me/alessandro_benedetti Blog - http://alexbenedetti.blogspot.co.uk "Tyger, tyger burning bright In the forests of the night, What immortal hand or eye Could frame thy fearful symmetry?" William Blake - Songs of Experience -1794 England --001a113d17b863cac105206aa5b8--