Postgres Pro
Downloads
Home   >   mailing lists

Re: very slow postgresql startup - Mailing list pgsql-admin

From Venkata Balaji N
Subject Re: very slow postgresql startup
Date
Msg-id CAEyp7J-zWzGX35VouHhu_s=9iR0_r=u+Y8_CvRNzUYyGxD7CpA@mail.gmail.com
Whole thread Raw
In response to very slow postgresql startup  (zz_11@mail.bg)
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Nguyen Hoai Nam
Date:
Subject: Re: The problem is related to concurrent resquests
Next
From: Magnus Hagander
Date:
Subject: Re: very slow postgresql startup