> -----Original Message----- > From: Alexander Staubo > > -> Nested Loop (cost=0.00..5729774.95 rows=10420 width=116) > (actual time=262614.470..262614.470 rows=0 loops=1) > Join Filter: ((photos.taken_at > (event_instances."time" + > '-01:00:00'::interval)) AND (photos.taken_at < (event_instances."time" > + '07:00:00'::interval))) > -> Nested Loop (cost=0.00..2055574.35 rows=11869630 > width=120) (actual time=21.750..121838.012 rows=14013998 loops=1)
Do you have any of the other enable_* options set to false? What do you have random_page_cost set to? I ask because I'm surprised to see postgres choose to loop when it knows it will have to loop 11 million times. Dave -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
