On Sunday 28 September 2003 09:19, David Griffiths wrote: > No difference. Note that all the keys that are used in the joins are > numeric(10)'s, so there shouldn't be any cast-issues.
Can you make them bigint and see? It might make some difference perhaps. Checking the plan in the meantime.. BTW what tuning you did to postgresql? Check http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html, assuming you haven't seen earlier.. HTH Shridhar ---------------------------(end of broadcast)--------------------------- TIP 3: 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
