X-Original-To: pgsql-performance@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 6814E925CAA for ; Thu, 22 May 2003 14:06:39 -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 67984-01 for ; Thu, 22 May 2003 14:06:06 -0400 (EDT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by developer.postgresql.org (Postfix) with ESMTP id 9F017925923 for ; Thu, 22 May 2003 12:32:30 -0400 (EDT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3056055; Thu, 22 May 2003 09:32:32 -0700 Content-Type: text/plain; charset="iso-8859-2" From: Josh Berkus Organization: Aglio Database Solutions To: "=?iso-8859-2?q?SZ=DBCS?= =?iso-8859-2?q?=20G=E1bor?=" , Subject: Re: ugly query slower in 7.3, even slower after vacuum full analyze Date: Thu, 22 May 2003 09:31:06 -0700 User-Agent: KMail/1.4.3 Cc: References: <008101c3206e$0dc8a310$0403a8c0@fejleszt4> In-Reply-To: <008101c3206e$0dc8a310$0403a8c0@fejleszt4> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200305220931.06110.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/212 X-Sequence-Number: 1991 Szucs, > This is a rather nasty query, built up from several parameters, and it > proved to be 7--15 times slower in 7.3 than in 7.2. This particular query > takes more than 3.5 minutes (4 after vacuum full analyze! (henceforth VFA)) > that is unacceptable in an interactive client application. Please read the list archives for the last 3-4 days. Another user reported a "slow query" problem with 7.3.2; please see if it sounds like yours. -- Josh Berkus Aglio Database Solutions San Francisco