From: Vicky Soni - Quipment India <vicky.soni@quipment.nl>
To: zz_11@mail.bg <zz_11@mail.bg>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: very slow postgresql startup
Date: Wed, 25 May 2016 11:04:06 +0000
Message-ID: <95cc35e427e6466d8f8b7dae8c62e283@Strand.quipment.local> (raw)
In-Reply-To: <fcc4fe9d1c72458c03a4dd25fc9404b6.mailbg@mail.bg>
References: <9d0b8595572cb24da5d2fcd13796d326.mailbg@mail.bg>
<fcc4fe9d1c72458c03a4dd25fc9404b6.mailbg@mail.bg>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi,
Can you please change log_min_message to debug2 and start service.
Check what postgresql is doing at start which takes time.
Also share some important lines from log file.
Thanks & Regards,
Vicky Soni
Database Administrator
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of zz_11@mail.bg
Sent: 25 May 2016 16:32
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] 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<mailto: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% отстъпка за нов хостинг план.
<http://ads.mail.bg/delivery/ck.php?oaparams=2__bannerid=4132__zoneid=35__OXLCA=1__cb=ad4c2831cb__oad...;
-------------------------------------
ПП: Видя ли специалните предложения на СуперХостинг.БГ? Ако имаш идеи за сайт, това е правилното място!
<http://ads.mail.bg/delivery/ck.php?oaparams=2__bannerid=4133__zoneid=35__OXLCA=1__cb=b98f26ba90__oad...;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vicky.soni@quipment.nl, zz_11@mail.bg
Subject: Re: very slow postgresql startup
In-Reply-To: <95cc35e427e6466d8f8b7dae8c62e283@Strand.quipment.local>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox