Re: very slow postgresql startup

From: Venkata Balaji N <nag1010(at)gmail(dot)com>
To: zz_11(at)mail(dot)bg
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: very slow postgresql startup
Date: 2016-05-23 09:19:01
Message-ID: CAEyp7J-zWzGX35VouHhu_s=9iR0_r=u+Y8_CvRNzUYyGxD7CpA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> After stopping my pg server with pg_ctl -m immediate stop options it
> take hours to startup.
>
> With vmstat I find hi pcu and io useages.
>
> Any idea about this problem? I think it can be pg_xlog files.
>
> How can I debug or trace this problem?
>
Do you see anything suspicious in the postgresql logfiles ? That can give
you a fair idea on what could be the issue.

Regards,
Venkata B N

Fujitsu Australia

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Magnus Hagander 2016-05-23 09:28:36 Re: very slow postgresql startup
Previous Message Nguyen Hoai Nam 2016-05-23 08:47:19 Re: The problem is related to concurrent resquests