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.