On Sat, 2004-11-06 at 12:52, Carlos Lopez wrote:
> I have migrated a database from MS SQL to a
> postgresSQL database, but when running it, the results
> are very slow (and unusable) which is the only reason
> we don't entirely move to postgresSQL.
> The problem is that there are many nested views which
> normally join tables by using two fields, one
> character and other integer.
If you are joining on different type fields, you might find the query
planner encouraged to use the indexes if you cast one field to the other
field's type. If that's possible.