RE: [GENERAL] slow queries

Поиск
Список
Период
Сортировка
От Jackson, DeJuan
Тема RE: [GENERAL] slow queries
Дата
Msg-id F10BB1FAF801D111829B0060971D839F42BF63@cpsmail
обсуждение исходный текст
Ответы Is there a server log????  (Jeremy Hansen <jeremy@xxedgexx.com>)
RE: [GENERAL] slow queries  (Howie <caffeine@toodarkpark.org>)
Список pgsql-general
> seems that by creating a view ( with the query i mentioned before ),
> my
> queries were sped up by roughly 10 seconds... odd odd odd.
>
Not really so odd when you think of everything the backend has to do to
process a query.  Parsing, planning, and optimizing (not necessarily in
that order) can be very costly.  A view basically skips most of those
three steps.
        -DEJ

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

Предыдущее
От: "Michael Ansley"
Дата:
Сообщение: Win32 libpq libraries
Следующее
От: Jeremy Hansen
Дата:
Сообщение: Is there a server log????