Re: 7.3 vs 7.2 - different query plan, bad 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.