"Daniel Cristian Cruz" <[EMAIL PROTECTED]> writes:

>   ->  Nested Loop  (cost=0.00..13187.94 rows=93 width=4) (actual 
> time=2.622..125.739 rows=50 loops=1)
>         ->  Seq Scan on u  (cost=0.00..2838.80 rows=10289 width=4) (actual 
> time=0.012..9.863 rows=10291 loops=1)
>         ->  Index Scan using m_pkey on m  (cost=0.00..0.80 rows=1 width=7) 
> (actual time=0.009..0.009 rows=0 loops=10291)

That's not discounting the nested loop for cache effect at all!

What is your effective_cache_size for this?

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to