X-Original-To: pgsql-performance@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id DDE7E475F00; Tue, 29 Apr 2003 10:53:47 -0400 (EDT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP
	id D645F476262; Tue, 29 Apr 2003 10:53:11 -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 h3TErEU6026551;
	Tue, 29 Apr 2003 10:53:14 -0400 (EDT)
To: "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano@mailbox.hu>
Cc: pgsql-performance@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: Query Plan far worse in 7.3.2 than 7.2.1 
In-reply-to: <00db01c30e54$1ab272d0$0a03a8c0@fejleszt2> 
References: <00db01c30e54$1ab272d0$0a03a8c0@fejleszt2>
Comments: In-reply-to "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano@mailbox.hu>
	message dated "Tue, 29 Apr 2003 15:01:21 +0200"
Date: Tue, 29 Apr 2003 10:53:13 -0400
Message-ID: <26550.1051627993@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Spam-Status: No, hits=-24.7 required=5.0
	tests=BAYES_01,IN_REP_TO,NO_DNS_FOR_FROM,QUOTED_EMAIL_TEXT,
	REFERENCES,REPLY_WITH_QUOTES autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/246
X-Sequence-Number: 1752

"=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano@mailbox.hu> writes:
> A nasty query and its EXPLAINs are here. Read on at your own risk :)

It's pretty much unreadable because of the way your mailer folded,
spindled, and mutilated the EXPLAIN output :-(

Could you resend in a more legible format?  Maybe append the explain
output as an attachment, if you can't get the mailer to leave its
formatting alone otherwise.

			regards, tom lane