Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
please find the EXPLAIN ANALYZE output.On Wed, Nov 15, 2017 at 3:13 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:Hiplease send EXPLAIN ANALYZE output.RegardsPavel2017-11-15 10:33 GMT+01:00 Samir Magar <samirmagar8@gmail.com>:Hello,I am having performance issues with one of the query.The query is taking 39 min to fetch 3.5 mil records.I want to reduce that time to 15 mins. could you please suggest something to its performance?server configuration: CPUs = 4memory = 16 GMshared_buffers = 3 GBwork_mem = 100MBeffective_cache_size = 12 GBwe are doing the vacuum/analyze regularly on the database. attached is the query with its explain plan.
Hiplease send EXPLAIN ANALYZE output.RegardsPavel2017-11-15 10:33 GMT+01:00 Samir Magar <samirmagar8@gmail.com>:Hello,I am having performance issues with one of the query.The query is taking 39 min to fetch 3.5 mil records.I want to reduce that time to 15 mins. could you please suggest something to its performance?server configuration: CPUs = 4memory = 16 GMshared_buffers = 3 GBwork_mem = 100MBeffective_cache_size = 12 GBwe are doing the vacuum/analyze regularly on the database. attached is the query with its explain plan.
Hello,I am having performance issues with one of the query.The query is taking 39 min to fetch 3.5 mil records.I want to reduce that time to 15 mins. could you please suggest something to its performance?server configuration: CPUs = 4memory = 16 GMshared_buffers = 3 GBwork_mem = 100MBeffective_cache_size = 12 GBwe are doing the vacuum/analyze regularly on the database. attached is the query with its explain plan.
Thanks,Samir Magar -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-performance
В списке pgsql-performance по дате отправления: