Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bPW10-0006Df-2d for pgsql-performance@arkaria.postgresql.org; Tue, 19 Jul 2016 14:28:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bPW0z-000268-MB for pgsql-performance@arkaria.postgresql.org; Tue, 19 Jul 2016 14:28:53 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bPW0y-00020A-5U for pgsql-performance@postgresql.org; Tue, 19 Jul 2016 14:28:52 +0000 Received: from smtp31.i.mail.ru ([94.100.177.91]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bPW0u-0004Zm-Mp for pgsql-performance@postgresql.org; Tue, 19 Jul 2016 14:28:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=mail.ru; s=mail2; h=Content-Transfer-Encoding:Content-Type:In-Reply-To:MIME-Version:Date:Message-ID:From:References:To:Subject; bh=ElVFr90h8Df/zfz9P57pRicZA2q0tCCXFWm3X+FvG5Q=; b=OrmaclBETFmy3LfyXudLJdri8uMFzaXRe0EYKXp6OJ3nfH0WkuFWPUxG47hxu4VAr2qaZRJSvXZYkZMUgDxCTWa9ApifQCFsKtfFm9ZFDKwfv3/HpncYl3PaXfRP47RNfdFbsxA8hrzGzGSRamYqrhzElGfORw3fuQI2Wd1I7E8=; Received: from c-50-156-112-176.hsd1.ca.comcast.net ([50.156.112.176]:12344 helo=[192.168.1.116]) by smtp31.i.mail.ru with esmtpa (envelope-from ) id 1bPW0p-0004Vn-NA; Tue, 19 Jul 2016 17:28:44 +0300 Subject: Re: less than 2 sec for response - possible? To: Jim Nasby , pgsql-performance@postgresql.org References: <38b8542e-e011-370d-3863-207126ac9b33@mail.ru> <94532c82-1dfa-5904-da2c-09adcffcf4f3@toco-domains.de> <0461b3e8-cb38-0ded-6e8c-48e6dc545ea6@mail.ru> <0027eadb-4d83-14e5-e6a3-15fcf4376841@toco-domains.de> <1d480b23-b7ed-413e-5ce9-cbf974bd8a9f@mail.ru> <1dcc1237-6134-e8e7-124e-ce5fffcff30b@toco-domains.de> <613bc616-7a2a-d1a2-25d4-da06e82c4347@mail.ru> From: trafdev Message-ID: Date: Tue, 19 Jul 2016 07:28:38 -0700 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Mras: OK X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org >>> The difference is - you're fetching\grouping 8 times less rows than I: > > Huh? The explain output certainly doesn't show that. Why not? My output: Buffers: shared hit=1486949 Torsten's output: Buffers: shared hit=155711 This is amount of rows fetched for further processing (when all data is in memory), isn't it? -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance