From: | zz_11(at)mail(dot)bg |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: very slow postgresql startup |
Date: | 2016-05-25 11:01:39 |
Message-ID: | fcc4fe9d1c72458c03a4dd25fc9404b6.mailbg@mail.bg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all,
after some investigation I found in pg database directory many files
starting with "t". For exmple:
-rw------- 1 postgres postgres 8192 May 25 11:13 t55_16771477
-rw------- 1 postgres postgres 8192 May 25 08:12 t55_16771482
-rw------- 1 postgres postgres 8192 May 25 09:07 t55_16771614
-rw------- 1 postgres postgres 8192 May 25 08:13 t55_16771632
-rw------- 1 postgres postgres 32768 May 25 07:05 t55_16772120
-rw------- 1 postgres postgres 24576 May 25 09:04 t55_16772120_fsm
-rw------- 1 postgres postgres 8192 May 25 12:11 t55_16772129
-rw------- 1 postgres postgres 0 May 25 08:40 t55_16772131
-rw------- 1 postgres postgres 0 May 25 12:09 t55_16772285
-rw------- 1 postgres postgres 0 May 25 09:44 t55_16772293
Can this one be the reason for slow pg start?
Many thanks in advance,
Ivan.
----- Цитат от zz_11(at)mail(dot)bg, на 23.05.2016 в 10:33 -----
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% отстъпка за нов хостинг план.
-------------------------------------
ПП: Видя ли специалните предложения на СуперХостинг.БГ? Ако имаш идеи за сайт, това е правилното място!
http://www.superhosting.bg/promo/spring?utm_source=MailBG&utm_medium=footer&utm_content=v2&utm_campaign=Spring2016
From | Date | Subject | |
---|---|---|---|
Next Message | Vicky Soni - Quipment India | 2016-05-25 11:04:06 | Re: very slow postgresql startup |
Previous Message | Vicky Soni - Quipment India | 2016-05-25 07:51:44 | Re: PITR Setup Using Hot StandBy |