* Henry Combrinck
It does appear to be using the index "article_pkey" (sa.id) unless I'm reading the above incorrectly...
Well, no, it's doing sequential scans ("Seq Scan") on both article and ticket, and you really want to avoid that. Here's what it would look like (modulo other local configuration issues that might influence the plan layout) if the indexes were used:
aah, crap, you're right! I had no idea pg7.4 ignored indexes if the types weren't *exactly* the same. system_user.id is integer... crikey, will need to monitor this and see what other tables are buggered. thanks for the pointers. Regards Henry -------------------------------------------------------- This message was sent using MetroWEB's AirMail service. http://www.metroweb.co.za/ - full access for only R73. Free Web Accelerator, WebMail, Calendar, Anti-Virus, Anti-Spam, 10 emails, 100MB personal webspace, and more! Phone Now! 086 11 11 440