Re: Query slows when used with view

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query slows when used with view
Дата
Msg-id 20080.1570629421@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Query slows when used with view  (Yavuz Selim Sertoğlu (ETIYA)<yavuz.sertoglu@etiya.com>)
Ответы RE: Query slows when used with view
Re: Query slows when used with view
Список pgsql-performance
=?iso-8859-9?Q?Yavuz_Selim_Serto=F0lu_=28ETIYA=29?= <yavuz.sertoglu@etiya.com> writes:
> I have a problem with views. When I use view in my query it really slows down(1.7seconds)
> If I use inside of view and add conditions and joins to it, it is really fast(0.7 milliseconds).
> I have no distinct/group/partition by in view so I have no idea why is this happening.
> I wrote queries and plans below.

Those are not equivalent queries.  Read up on the syntax of FROM;
particularly, that JOIN binds more tightly than comma.

            regards, tom lane



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

Предыдущее
От: Yavuz Selim Sertoğlu (ETIYA)
Дата:
Сообщение: Query slows when used with view
Следующее
От: Yavuz Selim Sertoğlu (ETIYA)
Дата:
Сообщение: RE: Query slows when used with view