X-Original-To: pgsql-performance@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 551A69250B8 for ; Wed, 21 May 2003 03:09:38 -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 19825-02 for ; Wed, 21 May 2003 03:09:05 -0400 (EDT) Received: from gate.solvo.ru (gate.solvo.ru [195.201.44.1]) by developer.postgresql.org (Postfix) with ESMTP id 7F6B19250EC for ; Wed, 21 May 2003 03:08:56 -0400 (EDT) Received: from grace.solvo.ru (grace.solvo.ru [195.201.44.100]) by gate.solvo.ru (8.8.8/8.8.8) with ESMTP id LAA14925; Wed, 21 May 2003 11:08:26 +0400 Received: from grace.solvo.ru (localhost [127.0.0.1]) by grace.solvo.ru (8.12.8/8.12.8) with ESMTP id h4L78QpD004879; Wed, 21 May 2003 11:08:26 +0400 Received: (from elf@localhost) by grace.solvo.ru (8.12.8/8.12.8/Submit) id h4L78Gj6004876; Wed, 21 May 2003 11:08:16 +0400 Date: Wed, 21 May 2003 11:08:16 +0400 From: Eugene Fokin To: Victor Yegorov Cc: pgsql-performance@postgresql.org Subject: Re: 7.3.2 vs 7.1.2 Message-ID: <20030521070816.GA4664@solvo.ru> References: <20030520122838.GA28654@solvo.ru> <20030520130913.GM1976@nordlb.lv> <20030520132842.GA29262@solvo.ru> <20030520140713.GN1976@nordlb.lv> <20030520153348.GA30541@solvo.ru> <20030520155801.GC4580@nordlb.lv> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030520155801.GC4580@nordlb.lv> User-Agent: Mutt/1.4i X-Operating-System: Linux 2.4.19-1pe i686 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/204 X-Sequence-Number: 1983 On Tue, May 20, 2003 at 06:58:01PM +0300, Victor Yegorov wrote: > > Try changing the join above to: > > loads l JOIN rcn_details r ON r.id = l.rcn_id > Nothing, I mean - the same result. > > Also, give the full description of fields, involved in your > load_rcn_id_idx and rcn_detail_idx indicies. > \d load_rcn_id_idx: Index "public.load_rcn_id_idx" Column | Type --------+--------- rcn_id | integer btree, for table "public.loads" \d loads: ... rcn_id | integer | not null default 0 ... \d rcn_detail_idx: Index "public.rcn_detail_idx" Column | Type --------+--------- id | integer unique, btree, for table "public.rcn_details" \d rcn_details: ... id | integer | default nextval('rcn_details_id'::text) ... \d rcn_details_id Sequence "public.rcn_details_id" Column | Type ---------------+--------- sequence_name | name last_value | bigint increment_by | bigint max_value | bigint min_value | bigint cache_value | bigint log_cnt | bigint is_cycled | boolean is_called | boolean -- Eugene Fokin SOLVO Ltd. Company