X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 470BC3A57B6 for ; Tue, 25 Jan 2005 18:02:43 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98005-04 for ; Tue, 25 Jan 2005 18:02:35 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id C92283A5780 for ; Tue, 25 Jan 2005 18:02:35 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j0PI2NIw005224; Tue, 25 Jan 2005 13:02:24 -0500 (EST) To: "Alexander Dolgin" Cc: pgsql-performance@postgresql.org Subject: Re: 200 times slower then MSSQL?? In-reply-to: References: Comments: In-reply-to "Alexander Dolgin" message dated "Mon, 24 Jan 2005 20:33:39 +0200" Date: Tue, 25 Jan 2005 13:02:23 -0500 Message-ID: <5223.1106676143@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/475 X-Sequence-Number: 10165 "Alexander Dolgin" writes: > Does anybody have idea about reasons of such results? Try converting the MAX() functions to queries that will use indexes. See FAQ entry 4.7 "My queries are slow or don't make use of the indexes. Why?" regards, tom lane