X-Original-To: pgsql-performance@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 5B8C3925015 for ; Tue, 20 May 2003 11:34: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 89372-07 for ; Tue, 20 May 2003 11:34:02 -0400 (EDT) Received: from gate.solvo.ru (gate.solvo.ru [195.201.44.1]) by developer.postgresql.org (Postfix) with ESMTP id CA9D0925016 for ; Tue, 20 May 2003 11:34:00 -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 TAA09303; Tue, 20 May 2003 19:33:49 +0400 Received: from grace.solvo.ru (localhost [127.0.0.1]) by grace.solvo.ru (8.12.8/8.12.8) with ESMTP id h4KFXnpD030585; Tue, 20 May 2003 19:33:49 +0400 Received: (from elf@localhost) by grace.solvo.ru (8.12.8/8.12.8/Submit) id h4KFXnto030583; Tue, 20 May 2003 19:33:49 +0400 Date: Tue, 20 May 2003 19:33:48 +0400 From: Eugene Fokin To: Victor Yegorov Cc: pgsql-performance@postgresql.org Subject: Re: 7.3.2 vs 7.1.2 Message-ID: <20030520153348.GA30541@solvo.ru> References: <20030520122838.GA28654@solvo.ru> <20030520130913.GM1976@nordlb.lv> <20030520132842.GA29262@solvo.ru> <20030520140713.GN1976@nordlb.lv> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030520140713.GN1976@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/196 X-Sequence-Number: 1975 On Tue, May 20, 2003 at 05:07:13PM +0300, Victor Yegorov wrote: > > As you can see, in 7.2.1 index scan on loads (load_rcn_id_idx) takes 0.04..786.13, > but in 7.3.2 - 0.07..4486.76. > > Also, note the difference in the: > > 7.2.1 "... rows=147281 width=4) ..." > 7.3.2 "... rows=147281 width=181) ..." > > My guesses: > > 1. Check your index. > 2. Do vacuum analyze again. > 3. This part: > (loads l JOIN (SELECT rcn_details.id, rcn_details.date_pour FROM rcn_details) r ON ((r.id = l.rcn_id))) > I've tried to simplify it, nothing happens -- the same effect ! The question is -- why it scans my indexes so long ? I've created "clean" experiment: the same machine, the same dump. And perform the same procedure for each DB (btw, now it's 7.2.4 vs 7.3.1 :-)): 1. Install DB. 2. Init DB. 3. Fix postgresql.conf 4. Load dump. 5. vacuum analyze. 6. query ! Difference is the same like 5 seconds vs 50 seconds... -- Eugene Fokin SOLVO Ltd. Company