[PERFORM] poor performance in migrated database

2004-11-06 Thread Carlos Lopez
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

Re: [PERFORM] poor performance in migrated database

2004-11-06 Thread Troels Arvin
On Sat, 06 Nov 2004 11:52:15 -0800, 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.

Re: [PERFORM] poor performance in migrated database

2004-11-06 Thread Simon Riggs
On Sat, 2004-11-06 at 19:52, Carlos Lopez wrote: The problem is that there are many nested views which normally join tables by using two fields, one character and other integer. PostgreSQL has difficulty with some multi-column situations, even though in general it has a particularly good query

Re: [PERFORM] poor performance in migrated database

2004-11-06 Thread Scott Marlowe
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