X-Original-To: pgsql-performance@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 135AA924ECA for ; Tue, 20 May 2003 08:28:47 -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 11894-03 for ; Tue, 20 May 2003 08:28:43 -0400 (EDT) Received: from gate.solvo.ru (gate.solvo.ru [195.201.44.1]) by developer.postgresql.org (Postfix) with ESMTP id 6EBB0924E23 for ; Tue, 20 May 2003 08:28:42 -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 QAA07402 for ; Tue, 20 May 2003 16:28:38 +0400 Received: from grace.solvo.ru (localhost [127.0.0.1]) by grace.solvo.ru (8.12.8/8.12.8) with ESMTP id h4KCScpD028664 for ; Tue, 20 May 2003 16:28:38 +0400 Received: (from elf@localhost) by grace.solvo.ru (8.12.8/8.12.8/Submit) id h4KCScJx028662 for pgsql-performance@postgresql.org; Tue, 20 May 2003 16:28:38 +0400 Date: Tue, 20 May 2003 16:28:38 +0400 From: Eugene Fokin To: pgsql-performance@postgresql.org Subject: 7.3.2 vs 7.1.2 Message-ID: <20030520122838.GA28654@solvo.ru> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4i X-Operating-System: Linux 2.4.19-1pe i686 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/190 X-Sequence-Number: 1969 Hello. I'm just going to upgrade from 7.1.2 to 7.3.2 and found that some of my queries performing on 7.3.2 much slower than on 7.1.2. For example, pretty complex query that takes 3-4 seconds on 7.1.2 now takes about 1 minute on 7.3.2. EXPLAIN shows the pretty same total query cost (49000 on 7.1.2 vs 56000 vs 7.3.2, but 7.1.2 didn't calculate some subqueries). What I did: make the dump from 7.1.2, load dump into 7.3.2, tune postgresql.conf parameters like in 7.1.2, vacuum analyze. Why is it take so long ? P.S. Of course, I can show the query. -- Eugene Fokin SOLVO Ltd. Company