X-Original-To: pgsql-performance@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id ACBB2925BAA for ; Thu, 22 May 2003 13:17:07 -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 45615-07 for ; Thu, 22 May 2003 13:17:05 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by developer.postgresql.org (Postfix) with ESMTP id 884E1925BCD for ; Thu, 22 May 2003 12:02:40 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4MG2cU6019627; Thu, 22 May 2003 12:02:38 -0400 (EDT) To: "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" Cc: pgsql-performance@postgresql.org, TIR@yahoogroups.com Subject: Re: ugly query slower in 7.3, even slower after vacuum full analyze In-reply-to: <008101c3206e$0dc8a310$0403a8c0@fejleszt4> References: <008101c3206e$0dc8a310$0403a8c0@fejleszt4> Comments: In-reply-to "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" message dated "Thu, 22 May 2003 16:25:54 +0200" Date: Thu, 22 May 2003 12:02:37 -0400 Message-ID: <19626.1053619357@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/211 X-Sequence-Number: 1990 "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" writes: > 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. I think you are running into the same subselect-in-targetlist shortcoming as Eugene Fokin did: http://archives.postgresql.org/pgsql-performance/2003-05/msg00204.php regards, tom lane