Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VtjzG-0006lH-NA for pgsql-performance@arkaria.postgresql.org; Thu, 19 Dec 2013 20:14:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VtjzG-0006yp-26 for pgsql-performance@arkaria.postgresql.org; Thu, 19 Dec 2013 20:14:26 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VtjzF-0006yj-4R for pgsql-performance@postgresql.org; Thu, 19 Dec 2013 20:14:25 +0000 Received: from nm4.bullet.mail.bf1.yahoo.com ([98.139.212.163]) by makus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vtjz8-0002wM-Ae for pgsql-performance@postgresql.org; Thu, 19 Dec 2013 20:14:24 +0000 Received: from [66.196.81.171] by nm4.bullet.mail.bf1.yahoo.com with NNFMP; 19 Dec 2013 20:14:17 -0000 Received: from [98.139.212.214] by tm17.bullet.mail.bf1.yahoo.com with NNFMP; 19 Dec 2013 20:14:17 -0000 Received: from [127.0.0.1] by omp1023.mail.bf1.yahoo.com with NNFMP; 19 Dec 2013 20:14:17 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 63512.76368.bm@omp1023.mail.bf1.yahoo.com Received: (qmail 58095 invoked by uid 60001); 19 Dec 2013 20:14:17 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1387484056; bh=9gCzet3HwLBo3T8JGzWDu3S7mJ8ZCUZAYHEdcO2T6no=; 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:Content-Transfer-Encoding; b=ncFI3SuRfiTf30QOLZffOFnY8GAEJrD488bWvddJ7eztivKgbsXV3UXabwlwMoV667jNzJ5BnP5lzCz6djkTFIxdBIUgnOAxPrbSTehjrGKMwuaKUnfT6eThgzYQ3cJeYZOPFxNaTstoEdRng4+jVU3mN2xth5xbNvG8iEcjhIk= 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:Content-Transfer-Encoding; b=X3kIKzK0qZKkfa2eNsDcvbHUA3HBxpqGOZpR7B46hQqkHS70Ydoq/4oDqzvs37ndW7/K0e8G7VzXW1hpuZDBJMCIEgTBjAvQAsvPI8iNoZsY2Kkg72yjw/CeDVPA0H5DJ1wMqltm7hw8lGn71UY99PCqqQBxpKCCJETb+xna4gA=; X-YMail-OSG: ywbXDfcVM1kr5APMBRMsIo3lEj2Wdbyxhba2bzxiW.q6L74 BwPkaxnl.U_QuMvtwc7qedR1JJ7yjIb6vy_IgUsll6i5x_i3mUVwigoNakqy OwxJY3Cdu8Slz6z__yVdmHKv0X5CBIa6ySRmRth2qi0R.K7E08y7UL2NiLIg 8nFsPkhU.fbxlU_bF31k.AB2Ycj9ZjfCgJ.0pDWpX5w5ME0abdCLMswV6RiN mgA7.2YjbjMwz_4MZVdIZdlZrep4sOO3W0F8U4XzOEVqF.FcybojXcoeOJxW 4fv1K3kaGjBw_szCAZdXBE6Ua0Q5MLbmuqT81x2_gi4QL5RfsTL8T9Xb6Q1m ltO71PsQ9IyuN3Cy13dAXd4chgU85OCft26VlJPSPGR4zLCo5pgZMtXGxDfJ BGI3Z3SWtVnYQq17bq_Wdgl0KQoSNHmJUQJmQCssyNpztZn.ONPUrhhVczhx 0R6xBceKR2DfA04EsQqNqHRPrpILt2rFycQb8oZH5Li1Gnz99LgDjK.bNhE0 kH5zmTUJdPsdWZ0mDRAgMWAcvh02sSgKU4PLx76AlG7tKk1OxIyzzPE_iMXC Xab9pMoF1EQNRekv0C2QzYZ_zvIGgpoJuxXHvPHnk Received: from [76.255.18.237] by web162906.mail.bf1.yahoo.com via HTTP; Thu, 19 Dec 2013 12:14:16 PST X-Rocket-MIMEInfo: 002.001, U2V2IFphc2xhdnNreSA8c2V2emFzQGdtYWlsLmNvbT4gd3JvdGU6CgpJIHdhbnQgdG8gYWdyZWUgd2l0aCBldmVyeXRoaW5nIFNoYXVuIHNhaWQgYW5kIGFkZCBhIHRpbnkgYml0LgoKPiBEb2VzIGxvYWRpbmcgMjRHYiBvZiBkYXRhIGluIDIxIHNlYyBzZWVtICJhYm91dCByaWdodCI_CgpJdCdzIGEgbGl0dGxlIG9uIHRoZSBzbG93IHNpZGUuwqAgWW91IHNhaWQgMTYzNCBwYWdlIHJlYWRzLsKgIEF0IDkgbXMKcGVyIHJlYWQgdGhhdCB3b3VsZCBiZSAxNC43IHNlY29uZHMuwqAgQnV0IEknbSBiYXNpbmcgdGgBMAEBAQE- X-Mailer: YahooMailWebService/0.8.172.614 References: <52A9F2A2.4080901@gmail.com> Message-ID: <1387484056.45481.YahooMailNeo@web162906.mail.bf1.yahoo.com> Date: Thu, 19 Dec 2013 12:14:16 -0800 (PST) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: slow query - will CLUSTER help? To: Sev Zaslavsky , "pgsql-performance@postgresql.org" In-Reply-To: <52A9F2A2.4080901@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -0.1 (/) 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 Sev Zaslavsky wrote: I want to agree with everything Shaun said and add a tiny bit. > Does loading 24Gb of data in 21 sec seem "about right"? It's a little on the slow side.=A0 You said 1634 page reads.=A0 At 9 ms per read that would be 14.7 seconds.=A0 But I'm basing the 9 ms per page read on my Linux experience, and I remember benchmarking the same application hitting PostgreSQL on the same hardware as about 30% faster on Linux than on Windows, so that *almost* makes up for the difference. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance