Re: Many to many join seems slow?

Drew Wilson wrote:
> Merge Join  (cost=524224.49..732216.29 rows=92447 width=97) (actual
> time=1088.871..1351.840 rows=170759 loops=1)
> ...
> Total runtime: 1366.757 ms

It looks like the query actual runs in less than 3 seconds, but it takes
some time to fetch 170759 rows to the client.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com