| From: | "Scott Marlowe" <smarlowe(at)qwest(dot)net> |
|---|---|
| To: | "Carlos Lopez" <chlopezl(at)yahoo(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] poor performance in migrated database |
| Date: | 2004-11-06 23:00:15 |
| Message-ID: | 1099782015.1310.39.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Iain | 2004-11-08 02:04:47 | Re: Help need to restore dropped db |
| Previous Message | Simon Riggs | 2004-11-06 21:39:10 | Re: [PERFORM] poor performance in migrated database |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ang Chin Han | 2004-11-07 11:04:16 | DISTINCT and GROUP BY: possible performance enhancement? |
| Previous Message | Simon Riggs | 2004-11-06 21:39:10 | Re: [PERFORM] poor performance in migrated database |