X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id E3E4730EECD for ; Mon, 16 Jun 2003 13:55:38 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 31182-05 for ; Mon, 16 Jun 2003 10:55:28 -0300 (ADT) Received: from nitrogen.id.pl (smtp.id.pl [193.178.214.4]) by svr1.postgresql.org (Postfix) with SMTP id D3D0E30EEC0 for ; Mon, 16 Jun 2003 10:55:21 -0300 (ADT) Received: (qmail 17521 invoked by uid 0); 16 Jun 2003 13:55:21 -0000 Received: from siaco.id.pl (213.25.114.8) by smtp.id.pl with SMTP; 16 Jun 2003 13:55:21 -0000 Received: (qmail 2529 invoked by uid 1000); 16 Jun 2003 13:55:21 -0000 Date: Mon, 16 Jun 2003 15:55:21 +0200 From: Ryszard Lach To: pgsql-performance@postgresql.org Subject: Re: 7.3 vs 7.2 - different query plan, bad performance Message-ID: <20030616135521.GO1734@siaco.id.pl> Reply-To: Ryszard Lach References: <20030613184506.GE21614@siaco.id.pl> <20030616063850.GA31813@siaco.id.pl> <373rev0fotgpq2osvlldf41b8flambulk9@4ax.com> <20030616114147.GJ1734@siaco.id.pl> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 Content-Disposition: inline In-Reply-To: X-My-GPG-Key: echo | mail -s "send key pub" siaco@allegro.pl> User-Agent: Mutt/1.5.4i X-Archive-Number: 200306/89 X-Sequence-Number: 2173 On Mon, Jun 16, 2003 at 03:24:52PM +0200, Manfred Koizar wrote: > On Mon, 16 Jun 2003 13:41:47 +0200, Ryszard Lach > wrote: > >On Mon, Jun 16, 2003 at 12:31:08PM +0200, Manfred Koizar wrote: > >> EXPLAIN ANALYSE SELECT * FROM v_c; > > >siaco=# explain analyze select count(*) from v_c; > ^^^^^^ ^ > See the difference? I bet if you > EXPLAIN ANALYSE SELECT * FROM v_c; > you get a much longer runtime. Yes, indeed. > BTW, did the index on a.parent_id help? In my test it improved > runtime from 59449.71 msec to 1203.26 msec (SELECT * with Postgres > 7.2). Oh yeah... Thanks a lot once more. Richard. -- "First they ignore you. Then they laugh at you. Then they fight you. Then you win." - Mohandas Gandhi.