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

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.

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).

Servus
 Manfred