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 you don't have a 7.4 install around to compare the plans do you? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com
