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 по дате отправления