Re: Slow query

Поиск
Список
Период
Сортировка
От Yonatan Goraly
Тема Re: Slow query
Дата
Msg-id 3F9CD067.7030301@sbcglobal.net
обсуждение исходный текст
Ответ на Re: Slow query  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список pgsql-general
yes

Alvaro Herrera wrote:

>On Mon, Oct 27, 2003 at 12:08:31AM +0200, Yonatan Goraly wrote:
>
>
>>I have a query that uses the same view 6 times. It seems that the
>>database engine is calculating the view each time.
>>The result is very poor performance. The same query takes 2 sec with MS
>>SQL, and more than 10 sec with PostgreSQL.
>>Is there a method to improve the performance besides merging the
>>components of the view into one table?
>>
>>
>
>Say, have you ANALYZEd your tables ?
>
>
>


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Slow query
Следующее
От: "Patrick Hatcher"
Дата:
Сообщение: Re: PostgreSQL with MS Query?