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

Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

From: "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
To: <pgsql-general@postgresql.org>
Date: 2002-10-16T14:16:01Z
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.