Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 5684F632A0A for ; Thu, 7 Jan 2010 20:39:04 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 70290-10 for ; Fri, 8 Jan 2010 00:38:46 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.9]) by mail.postgresql.org (Postfix) with ESMTP id 251DE632553 for ; Thu, 7 Jan 2010 20:38:53 -0400 (AST) Received: from [192.168.1.3] (pool-96-244-14-10.bltmmd.fios.verizon.net [96.244.14.10]) by mrelayeu.kundenserver.de (node=mrbap0) with ESMTP (Nemesis) id 0MJmWC-1NRwPQ0epA-001jr7; Fri, 08 Jan 2010 01:38:37 +0100 Message-ID: <4B467E8A.5000207@2ndquadrant.com> Date: Thu, 07 Jan 2010 19:38:34 -0500 From: Greg Smith User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: depesz@depesz.com CC: Lefteris , pgsql-performance@postgresql.org Subject: Re: Air-traffic benchmark References: <852badbc1001070438j36eb10d3qa22398ffcbef405f@mail.gmail.com> <20100107233933.GA19526@depesz.com> In-Reply-To: <20100107233933.GA19526@depesz.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX18KgxvF1UvYWz+ojmb1BCB1AtD7w459XJwnwJ4 QuIsx0rsktVD/IqcOEwJ9x4aPSTLXxMV4S0dasLi6OUTe8FhBr EIIHSuD5vYkmaEeqqZaBxHVzgqE02I5 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.503 tagged_above=-10 required=5 tests=AWL=-0.763, BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 201001/129 X-Sequence-Number: 37009 hubert depesz lubaczewski wrote: > Well, this query basically has to be slow. Correct approach to this > problem is to add precalculated aggregates... The point of this data set and associated queries is to see how fast the database can do certain types of queries on its own. Some other types of database implementations automatically do well here due to column storage and other techniques; the idea is to measure how you can do without trying to rewrite the app any though. If precomputed aggregates were added, they'd improve performance for everybody else, too. -- Greg Smith 2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.com