am Wed, dem 12.12.2007, um 12:25:20 +0000 mailte Ashish Karalkar folgendes: > > here is the output from planner: > > Nested Loop IN Join (cost=0.00..5030217.97 rows=2 width=106) > > -> Seq Scan on sms_new (cost=0.00..5027902.00 rows=384 width=106) > > Filter: (mobile = 919820920858::bigint) > > Do you have an index on "mobile"? Can you show us the table definition > and the output from EXPLAIN ANALYSE? > > no index on mobile Seq Scan on sms_new ... Filter: (mobile = 919820920858::bigint) (cost=0.00..5027902.00 Can you see the problem? Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
