On Mon, 16 Jun 2003 13:41:47 +0200, Ryszard Lach <siaco(at)autograf(dot)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