On Tue, Oct 25, 2005 at 10:26:43PM -0600, Sidar López Cruz wrote: > look at this: > select count(*) from fotos where archivo not in (select archivo from > archivos) > Aggregate (cost=4899037992.36..4899037992.37 rows=1 width=0) > -> Seq Scan on fotos (cost=22598.78..4899037338.07 rows=261716 width=0) > Filter: (NOT (subplan)) > SubPlan > -> Materialize (cost=22598.78..39304.22 rows=805344 width=58) > -> Seq Scan on archivos (cost=0.00..13141.44 rows=805344 > width=58)
Now, this is interesting; it seems to trigger exactly the same oddity as my query did (at least one of them; the materialized sequential scan). /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(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
