Re: Queries take forever on ported database from MSSQL -> Postgresql - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: Queries take forever on ported database from MSSQL -> Postgresql
Date
Msg-id 3DADC1F9.25326.116E324@localhost
Whole thread Raw
In response to Queries take forever on ported database from MSSQL -> Postgresql  ("Robert John Shepherd" <robert@reviewer.co.uk>)
List 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.


pgsql-general by date:

Previous
From: Jeff Boes
Date:
Subject: Re: cannot open segment 1 of relation...
Next
From: Richard Huxton
Date:
Subject: Re: RV: bad result in a query!! hopeless