Re: very slow postgresql startup

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@mail.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% отстъпка за нов хостинг план.

-------------------------------------
ПП: Видя ли специалните предложения на СуперХостинг.БГ? Ако имаш идеи за сайт, това е правилното място!