X-Original-To: pgsql-performance@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id CB33F925069 for ; Tue, 20 May 2003 11:55:14 -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 95759-04 for ; Tue, 20 May 2003 11:55:11 -0400 (EDT) Received: from shield.nordlb.lv (shield.pirmabanka.lv [195.114.57.4]) by developer.postgresql.org (Postfix) with ESMTP id 99663925063 for ; Tue, 20 May 2003 11:55:10 -0400 (EDT) Received: from wall2.pirmabanka.lv (wall2-pub.nordlb.lv [195.114.57.14]) by shield.nordlb.lv (8.12.9/8.12.9) with SMTP id h4KFt8bg024735 for ; Tue, 20 May 2003 18:55:08 +0300 Received: from share.nordlb.lv ([10.0.0.10]) by wall2.pirmabanka.lv; Tue, 20 May 2003 18:55:06 +0300 (EET DST) Received: from pc311x1.nordlb.lv (localhost.localdomain [127.0.0.1]) by nordlb.lv (8.11.6/8.11.6) with SMTP id h4KFt5j28391 for ; Tue, 20 May 2003 18:55:05 +0300 Received: (qmail 4687 invoked by uid 100); 20 May 2003 15:58:01 -0000 Date: Tue, 20 May 2003 18:58:01 +0300 From: Victor Yegorov To: Eugene Fokin Cc: pgsql-performance@postgresql.org Subject: Re: 7.3.2 vs 7.1.2 Message-ID: <20030520155801.GC4580@nordlb.lv> References: <20030520122838.GA28654@solvo.ru> <20030520130913.GM1976@nordlb.lv> <20030520132842.GA29262@solvo.ru> <20030520140713.GN1976@nordlb.lv> <20030520153348.GA30541@solvo.ru> Mime-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Disposition: inline In-Reply-To: <20030520153348.GA30541@solvo.ru> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/198 X-Sequence-Number: 1977 * Eugene Fokin [20.05.2003 18:38]: > > (loads l JOIN (SELECT rcn_details.id, rcn_details.date_pour FROM rcn_details) r ON ((r.id = l.rcn_id))) > > Try changing the join above to: loads l JOIN rcn_details r ON r.id = l.rcn_id Also, give the full description of fields, involved in your load_rcn_id_idx and rcn_detail_idx indicies. -- Victor Yegorov