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
