Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
I've reduced default_statistics_target to 200, and saw less nested loops.I'm trying some changes to the query, but no better results.The table presenca has 26 million rows. The table aula_confirmacao has 840 thousand rows.2013/3/21 Daniel Cristian Cruz <danielcristian@gmail.com>Hi, I'm trying to figure out why does the planner found 1 row estimate using nested loops over a big table. There is no return from it:http://explain.depesz.com/s/GRsIt returns if disable nested loops, but the plan still poor:http://explain.depesz.com/s/fMYI'm using PostgreSQL 9.2.3, default_statistics_target on 1000.I can't remember what to make PostgreSQL sees a better estimate in the scan of aula_confirmacao and the join with presenca. I got rusty after a long time just doing modeling.Does someone has some idea on that?Thanks,-- Daniel Cristian Cruzクルズ クリスチアン ダニエル-- Daniel Cristian Cruzクルズ クリスチアン ダニエル
Hi, I'm trying to figure out why does the planner found 1 row estimate using nested loops over a big table. There is no return from it:http://explain.depesz.com/s/GRsIt returns if disable nested loops, but the plan still poor:http://explain.depesz.com/s/fMYI'm using PostgreSQL 9.2.3, default_statistics_target on 1000.I can't remember what to make PostgreSQL sees a better estimate in the scan of aula_confirmacao and the join with presenca. I got rusty after a long time just doing modeling.Does someone has some idea on that?Thanks,-- Daniel Cristian Cruzクルズ クリスチアン ダニエル
В списке pgsql-general по дате отправления: