Postgres Pro
Downloads
Home   >   mailing lists

very slow postgresql startup - Mailing list pgsql-admin

From zz_11@mail.bg
Subject very slow postgresql startup
Date
Msg-id 9d0b8595572cb24da5d2fcd13796d326.mailbg@mail.bg
Whole thread Raw
Responses Re: very slow postgresql startup  (Venkata Balaji N <nag1010@gmail.com>)
Re: very slow postgresql startup  (Magnus Hagander <magnus@hagander.net>)
Re: very slow postgresql startup  (zz_11@mail.bg)
Re: very slow postgresql startup  (Alex Ignatov <a.ignatov@postgrespro.ru>)
[ADMIN] postgres account disabled . version 9.2  (koffi BADOH <koff10@hotmail.com>)
List pgsql-admin
Tree view

Hi,


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?

pg version is 9.4.5 running on centos 6.

Many thanks in advance.




-------------------------------------
ПП: Ако имаш идеи за сайт, виж какво предлагат СуперХостинг.БГ. Тази пролет дават -75% отстъпка за нов хостинг план.

pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: The problem is related to concurrent resquests
Next
From: Nguyen Hoai Nam
Date:
Subject: Re: The problem is related to concurrent resquests