RE: [GENERAL] slow queries

Поиск
Список
Период
Сортировка
Искать
От
Jackson, DeJuan
Тема
RE: [GENERAL] slow queries
Дата
Msg-id
F10BB1FAF801D111829B0060971D839F42BF63@cpsmail
Список
Дерево обсуждения
RE: [GENERAL] slow queries "Jackson, DeJuan" <djackson@cpsgroup.com>
RE: [GENERAL] slow queries Howie <caffeine@toodarkpark.org>
Is there a server log???? Jeremy Hansen <jeremy@xxedgexx.com>
Re: [GENERAL] Is there a server log???? rmcm@compsoft.com.au
> 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????
FAQ