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

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: Queries take forever on ported database from MSSQL -> Postgresql
Дата
Msg-id 3DADC1F9.25326.116E324@localhost
обсуждение исходный текст
Ответ на Queries take forever on ported database from MSSQL -> Postgresql  ("Robert John Shepherd" <robert@reviewer.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Boes
Дата:
Сообщение: Re: cannot open segment 1 of relation...
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: RV: bad result in a query!! hopeless