Re: 7.3 vs 7.2 - different query plan, bad performance - Mailing list pgsql-performance

From Ryszard Lach
Subject Re: 7.3 vs 7.2 - different query plan, bad performance
Date
Msg-id 20030616135521.GO1734@siaco.id.pl
Whole thread Raw
In response to Re: 7.3 vs 7.2 - different query plan, bad performance  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-performance
On Mon, Jun 16, 2003 at 03:24:52PM +0200, Manfred Koizar wrote:
> On Mon, 16 Jun 2003 13:41:47 +0200, Ryszard Lach <siaco@autograf.pl>
> 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.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: left join performance problem
Next
From: Tom Lane
Date:
Subject: Re: Partial index where clause not filtering through