Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VqRrS-0004oa-VE for pgsql-performance@arkaria.postgresql.org; Tue, 10 Dec 2013 18:16:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VqRrS-0002f8-El for pgsql-performance@arkaria.postgresql.org; Tue, 10 Dec 2013 18:16:46 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VqRrR-0002f1-3e for pgsql-performance@postgresql.org; Tue, 10 Dec 2013 18:16:45 +0000 Received: from nm34-vm3.bullet.mail.bf1.yahoo.com ([72.30.239.75]) by makus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VqRrN-0004lw-NL for pgsql-performance@postgresql.org; Tue, 10 Dec 2013 18:16:44 +0000 Received: from [98.139.215.141] by nm34.bullet.mail.bf1.yahoo.com with NNFMP; 10 Dec 2013 18:16:40 -0000 Received: from [98.139.212.222] by tm12.bullet.mail.bf1.yahoo.com with NNFMP; 10 Dec 2013 18:16:40 -0000 Received: from [127.0.0.1] by omp1031.mail.bf1.yahoo.com with NNFMP; 10 Dec 2013 18:16:40 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 461740.66735.bm@omp1031.mail.bf1.yahoo.com Received: (qmail 58469 invoked by uid 60001); 10 Dec 2013 18:16:40 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1386699400; bh=lvK9ZPXMOow+QL9F4XqhkSnQtjiQKAfOAaXK0qLo65Q=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=YRxh3RF1+mLvixlzX0Lyz0WKYo5rD/GvddIxcoLoghMvSvUqcC4aCfRlYMywbaU2Jo4VnjrKoiT+AnAAK3U78LbcKRMcaSO0fli2KTJbn3EiEx+tFdXx4O5+yBOD6LF1pu4VrDpS/Zov5AIFnITmx69/e2VHtQW+crzbzySvuvk= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=tvyI3gRgJ/AwfPHg18/C/5vhp+YysrhSPxx2OnO9ZS6T2uMMce7OCNxW/SYFyvgQtoLMqyO0zd/cl1mhsK7dIrD9sdVlVXotfZG7tphN/L2sI0icThpfyctzbp9qxUG0UTl//YOrNkn5DRRoywDYZbHeq73jH85NJwPT581css4=; X-YMail-OSG: y5eMFycVM1kOkW8R8tXNjEJrgU7hYcpVgIKooqBQIvxIzjK FW0L3_yfYW_R87tE23HUrrrzNWp.MVnTmZ_cFvioV907r6OgMsZDUpoQ6W.V cIgoL6HXNQxGAxRc3xlh.VwJRT4NPcX.8V_WmC8BuBXZbwwJliTWuAvYnnOp d1_RGeO93yVhJ4dFl.ozOf6tlvXhHZw6K6jTbEDgEAMuCLFRZvQc6x0R48rx 56L2SEcesqOaIkQPjesWr3ytgjtmJx.0uDUBf5OutojzcyNn3.qP01IJgY2M dxWr7RXCPkYO4PR0YH3GQHXcpRUQ7Jb1OF4nsVTXJ5IPsopPN3qnOG1oDfkx oOkF.LExW9DrS1GhkwNrsafIRzLxWY26smgFxTv1HodoAd1Zt65qCBMCAgaA vIoR3QhxXYAxSK43gahUXXh6uJs1MydjlYPL92sNbZ0I5yZgof6pzXi3Ysip DbGkX9vX59uGkmCYj7JJaNZLPbadtJMs.tBtj3JtfZGhlvsDiLJ7YsLWEs3D pbr4FRoz8kEfCyuwzPghWxLi5m3G.aJ4XPYJlKaYxPRP5yEXPP7e7Exf3Jd3 EQzdVSsolhaVKIfhIjeb8MZW7Xd1N6qpajc8RJc.dSkYg08LR4NVX7hYMqAe JJj0__fZQh3Oy8OF27nTwi3bVPrR5RYuLTZXFnK7JT4GZGQUVZo91ydQqPTv 0TvUpkLw6qNsICmmUBiH5Pc6_4ECWMeVu1pjRyDLsw.MhoXdR_lTVl.4jCOE iP9S_YVi.MUhVlNV5OQ8jMbIW Received: from [76.255.18.237] by web162903.mail.bf1.yahoo.com via HTTP; Tue, 10 Dec 2013 10:16:40 PST X-Rocket-MIMEInfo: 002.001, amFja2V0NDExNDIgPGphY2tldDQxMTQyQGdtYWlsLmNvbT4gd3JvdGU6Cgo.IFsgc3ViamVjdCBpc3N1ZSBpbiBkZXRhaWwgXQoKUGxlYXNlIHJldmlldyB0aGlzIHRocmVhZDoKCmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9mbGF0L0NBUE5ZLTJVdGNlLWMra05Ud3NNQ2JBazU4PTltWWVBZVZpVFhUOUxPN3Ixazc3anVrd0BtYWlsLmdtYWlsLmNvbSNDQVBOWS0yVXRjZS1jK2tOVHdzTUNiQWs1OD05bVllQWVWaVRYVDlMTzdyMWs3N2p1a3dAbWFpbC5nbWFpbC5jb20KCi0tCktldmluIEcBMAEBAQE- X-Mailer: YahooMailWebService/0.8.169.609 References: Message-ID: <1386699400.50339.YahooMailNeo@web162903.mail.bf1.yahoo.com> Date: Tue, 10 Dec 2013 10:16:40 -0800 (PST) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: select count(distinct ...) is slower than select distinct in about 5x To: jacket41142 , "pgsql-performance@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Pg-Spam-Score: 0.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 jacket41142 wrote: > [ subject issue in detail ] Please review this thread: http://www.postgresql.org/message-id/flat/CAPNY-2Utce-c+kNTwsMCbAk58=9mYeAeViTXT9LO7r1k77jukw@mail.gmail.com#CAPNY-2Utce-c+kNTwsMCbAk58=9mYeAeViTXT9LO7r1k77jukw@mail.gmail.com -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance