On Jan 26, 2018 3:00 AM, "Alvaro Herrera" <alvherre@alvh.no-ip.org> wrote:pavan95 wrote: > Hi Álvaro Herrera, > > Please find the corresponding output:OK, these settings look pretty normal, so they don't explain your problem. What is checkpoint_segments set to? And checkpoint_timeout? -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services Hi, checkpoint_segments are set to '3' & checkpoint_timeout was set to '5 min'. Regards, Pavan.
pavan95 wrote: > Hi Álvaro Herrera, > > Please find the corresponding output:OK, these settings look pretty normal, so they don't explain your problem. What is checkpoint_segments set to? And checkpoint_timeout? -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных