X-Original-To: pgsql-performance@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 1E263925727 for ; Thu, 22 May 2003 14:13:48 -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 69047-07 for ; Thu, 22 May 2003 14:13:08 -0400 (EDT) Received: from mail.deltav.hu (unknown [213.163.0.192]) by developer.postgresql.org (Postfix) with ESMTP id 353D3925872 for ; Thu, 22 May 2003 12:34:02 -0400 (EDT) Received: from fejleszt4 ([213.163.10.103]) by mail.deltav.hu (Netscape Messaging Server 3.6) with SMTP id AAAA01 for ; Thu, 22 May 2003 18:34:00 +0200 Message-ID: <012e01c3207f$c80b3920$0403a8c0@fejleszt4> From: "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" To: References: <008101c3206e$0dc8a310$0403a8c0@fejleszt4> <19626.1053619357@sss.pgh.pa.us> Subject: Re: ugly query slower in 7.3, even slower after vacuum full analyze Date: Thu, 22 May 2003 18:32:48 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/213 X-Sequence-Number: 1992 Dear Tom, (or anyone who followed the belowmentioned thread) I read that thread (more-or-less), but couldn't have noticed the same symptoms in my analyze output. So, to summarize my reading on this (please confirm or fix): * The symptom is the differing width in 7.2 and 7.3 * This causes more hdd work, that takes lots of time (indeed, the hdd was going crazy) * The query is probably good as it is; it's 7.3 that's slow (but more reliable than 7.2) and 7.4 will most likely fix the problem. If all these are correct, that's enough info to me. Hopefully it'll move from a Cel333 (the developers' server) to an IBM 2x2.4 Xeon with 5-HDD SCSI Raid (the business server). G. ------------------------------- cut here ------------------------------- ----- Original Message ----- From: "Tom Lane" Sent: Thursday, May 22, 2003 6:02 PM Subject: Re: [PERFORM] ugly query slower in 7.3, even slower after vacuum full analyze > "=?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 >