X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id F32D79FA218 for ; Fri, 26 May 2006 14:55:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 84799-01 for ; Fri, 26 May 2006 14:55:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 42EB39FA12E for ; Fri, 26 May 2006 14:55:17 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k4QHtGf4027571; Fri, 26 May 2006 13:55:16 -0400 (EDT) To: "Merlin Moncure" cc: "Postgresql Performance" Subject: Re: is it possible to make this faster? In-reply-to: References: <15919.1148590347@sss.pgh.pa.us> <16119.1148591497@sss.pgh.pa.us> <25668.1148653358@sss.pgh.pa.us> <27137.1148663259@sss.pgh.pa.us> Comments: In-reply-to "Merlin Moncure" message dated "Fri, 26 May 2006 13:46:30 -0400" Date: Fri, 26 May 2006 13:55:15 -0400 Message-ID: <27570.1148666115@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/497 X-Sequence-Number: 19284 "Merlin Moncure" writes: > can't thing of anything, I'm running completely stock, did you do a > optimize table foo? Nope, never heard of that before. But I did it, and it doesn't seem to have changed my results at all. > mysql> select user_id, acc_id, max(sample_date) from usage_samples group by 1,2 > 939 rows in set (0.07 sec) 0.07 seconds is not impossibly out of line with my result of 0.15 sec, maybe your machine is just 2X faster than mine. This is a 2.8GHz dual Xeon EM64T, what are you testing? You said "less than 20 msec" before, what was that on? regards, tom lane