Re: Slow shutdowns sometimes on RDS Postgres

Поиск
Список
Период
Сортировка
От Juan Manuel Cuello
Тема Re: Slow shutdowns sometimes on RDS Postgres
Дата
Msg-id CALXCfb1DHWZbG9F_kXSHJKOET0ks3LtyH4jXFQ-QbB0wdmO90w@mail.gmail.com
обсуждение исходный текст
Ответ на Slow shutdowns sometimes on RDS Postgres  (Chris Williams <cswilliams@gmail.com>)
Список pgsql-general
On Thu, Sep 13, 2018 at 7:05 PM Chris Williams <cswilliams@gmail.com> wrote:
We just have a few ruby on rails applications connected to the database, and don't really have any long running or heavy queries and the db is under very light load, so I don't understand why it takes so long to shutdown.  We do have a sizeable number of connections though (about 600) and there are two replicas connected to it.  I also tried setting idle_in_transaction_session_timeout to 300 seconds to see if that would help, but it made no difference.

If you only have a few rails apps connected to the DB and a very light load, may be you can try reducing the number of connections (how big are your connection pools?) and see if that helps. 600 seems to be a big value for just a few apps and a light load. 

 
 

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [External] RE: Estimate time without running the query
Следующее
От: Robert Eckhardt
Дата:
Сообщение: Re: Code of Conduct plan