X-Original-To: pgsql-performance@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 20B449250F1 for ; Wed, 21 May 2003 03:25:10 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 23843-05 for ; Wed, 21 May 2003 03:24:59 -0400 (EDT) Received: from gate.solvo.ru (gate.solvo.ru [195.201.44.1]) by developer.postgresql.org (Postfix) with ESMTP id 21F969250CE for ; Wed, 21 May 2003 03:24:53 -0400 (EDT) Received: from grace.solvo.ru (grace.solvo.ru [195.201.44.100]) by gate.solvo.ru (8.8.8/8.8.8) with ESMTP id LAA14980; Wed, 21 May 2003 11:19:12 +0400 Received: from grace.solvo.ru (localhost [127.0.0.1]) by grace.solvo.ru (8.12.8/8.12.8) with ESMTP id h4L7JCpD004938; Wed, 21 May 2003 11:19:12 +0400 Received: (from elf@localhost) by grace.solvo.ru (8.12.8/8.12.8/Submit) id h4L7J36q004936; Wed, 21 May 2003 11:19:03 +0400 Date: Wed, 21 May 2003 11:19:03 +0400 From: Eugene Fokin To: Tom Lane Cc: Victor Yegorov , pgsql-performance@postgresql.org Subject: Re: 7.3.2 vs 7.1.2 Message-ID: <20030521071903.GC4664@solvo.ru> References: <20030520122838.GA28654@solvo.ru> <20030520130913.GM1976@nordlb.lv> <20030520132842.GA29262@solvo.ru> <20030520140713.GN1976@nordlb.lv> <29699.1053448821@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <29699.1053448821@sss.pgh.pa.us> User-Agent: Mutt/1.4i X-Operating-System: Linux 2.4.19-1pe i686 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/206 X-Sequence-Number: 1985 On Tue, May 20, 2003 at 12:40:21PM -0400, Tom Lane wrote: > > [...skipped...] > > I'm not sure whether selecting the count from this view is really all > that important to Eugene, but if it is he could make an alternate view > that has the same FROM clause and nothing interesting in its select > list, and then count that. > This is the one sample from the working system for which I'm trying to upgrade the database. And you're right. I've removed all subqueries from select list and I've got original 5 seconds ! After that I tried to add one subquery back (the simpliest one) and got the same 40-50 seconds again ! -- Eugene Fokin SOLVO Ltd. Company