Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Hi everyone, I’m using LIMIT offset with DB view. Looks like query planner is applying the LIMIT for DB view at the end after processing all rows.When running same SQL that was used to create the DB view, LIMIT is applied earlier so the query is much faster. Explain plan using DB view https://explain.depesz.com/s/gzjQ Explain plan using raw SQLhttps://explain.depesz.com/s/KgwO In both tests LIMIT was 100 with offset = 0.Is there any way to force DB view to apply limit earlier? Thanks,Raj
Hi everyone,
I’m using LIMIT offset with DB view. Looks like query planner is applying the LIMIT for DB view at the end after processing all rows.
When running same SQL that was used to create the DB view, LIMIT is applied earlier so the query is much faster.
Explain plan using DB view
https://explain.depesz.com/s/gzjQ
Explain plan using raw SQL
https://explain.depesz.com/s/KgwO
In both tests LIMIT was 100 with offset = 0.
Is there any way to force DB view to apply limit earlier?
Thanks,
Raj
В списке pgsql-admin по дате отправления: