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.