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.
Have you run ANALYZE lately? (See manual.
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
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 que
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.
