Gregory Stark wrote:
Those plans look like they have a lot of casts to text in them. How have you defined your indexes? Are your id columns really text?
And did you use the same encoding and locale? Text operations on multibyte encodings are much more expensive.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(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