Re: Very slow query

Поиск
Список
Период
Сортировка
От Paul Thomas
Тема Re: Very slow query
Дата
Msg-id 20040511084244.A25409@bacon
обсуждение исходный текст
Ответ на Re: Very slow query  (Rory Campbell-Lange <rory@campbell-lange.net>)
Список pgsql-general
On 10/05/2004 22:30 Rory Campbell-Lange wrote:
> Sorry for replying to my own post, but I'm anxious for an answer. Should
> I provide other information?

Look carefully at your column types. I can see several smallint columns in
there WHERE clause which are not expicitely typed as such.

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business             |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

В списке pgsql-general по дате отправления:

Предыдущее
От: "Stijn Vanroye"
Дата:
Сообщение: Re: Cancel query based on a timeout
Следующее
От: Rory Campbell-Lange
Дата:
Сообщение: Postgres demo app [was: Re: nested elseif woes]