Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 16 Oct 2002 19:46:01 +0530
- Message-id: <3DADC1F9.25326.116E324@localhost> <text/plain>
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.
- References:
- Queries take forever on ported database from MSSQL -> Postgresql
- From: Robert John Shepherd
- Queries take forever on ported database from MSSQL -> Postgresql
- Prev by Date: Re: cannot open segment 1 of relation...
- Next by Date: Re: RV: bad result in a query!! hopeless
- Previous by thread: Re: Queries take forever on ported database from MSSQL -> Postgresql (SOLVED)
- Next by thread: information
- Indexes: