Re: Queries take forever on ported database from MSSQL -> Postgresql

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Queries take forever on ported database from MSSQL -> Postgresql
Date: 2002-10-16 14:16:01
Message-ID: 3DADC1F9.25326.116E324@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 16 Oct 2002 at 14:30, Robert John Shepherd wrote:
> Alas what took MS-SQL 500ms to do is taking Postgresql about 140
> seconds, obviously completely unacceptable. Even the simplest queries
> seem to take far longer than I expected them to. :/

Can you post your (audited) schemas and queries related to that, That might
give a clue..

HTH

Bye
Shridhar

--
Gordon's Law: If you think you have the solution, the question was poorly
phrased.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-10-16 15:06:29 Re: Corrupt database
Previous Message Adam Siegel 2002-10-16 14:01:04 pg_dump on large columns