pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedvery slow postgresql startup
7+ messages / 5 participants
[nested] [flat]
* very slow postgresql startup
@ 2016-05-23 08:33 zz_11@mail.bg
0 siblings, 4 replies; 7+ messages in thread
From: zz_11@mail.bg @ 2016-05-23 08:33 UTC (permalink / raw)
To: pgsql-admin
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=v1&a...
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: very slow postgresql startup
@ 2016-05-23 09:19 Venkata Balaji N <nag1010@gmail.com>
parent: zz_11@mail.bg
3 siblings, 0 replies; 7+ messages in thread
From: Venkata Balaji N @ 2016-05-23 09:19 UTC (permalink / raw)
To: zz_11@mail.bg; +Cc: pgsql-admin
> 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: very slow postgresql startup
@ 2016-05-23 09:28 Magnus Hagander <magnus@hagander.net>
parent: zz_11@mail.bg
3 siblings, 1 reply; 7+ messages in thread
From: Magnus Hagander @ 2016-05-23 09:28 UTC (permalink / raw)
To: zz_11@mail.bg; +Cc: pgsql-admin
On May 23, 2016 10:35, <zz_11@mail.bg> wrote:
>
> 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.
This is not uncommon when you shutdown with immediate. It's the main reason
you should normally use fast and not immediate.
And yes, it's likely the replay of xlog. Hours is a very long time though,
but with very high checkpoint timeout that's certainly possible.
/Magnus
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: very slow postgresql startup
@ 2016-05-23 09:49 zz_11@mail.bg
parent: Magnus Hagander <magnus@hagander.net>
0 siblings, 0 replies; 7+ messages in thread
From: zz_11@mail.bg @ 2016-05-23 09:49 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; +Cc: pgsql-admin
Hi,
Thank you.
Any idea how to view the progress?
Regards,
Ivan.
----- Цитат от Magnus Hagander (magnus@hagander.net), на
23.05.2016 в 11:28 -----
On May 23, 2016 10:35, wrote:
>
> 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.
This is not uncommon when you shutdown with immediate. It's the main reason
you should normally use fast and not immediate.
And yes, it's likely the replay of xlog. Hours is a very long time though,
but with very high checkpoint timeout that's certainly possible.
/Magnus
Links:
------
[1] mailto:zz_11@mail.bg
-------------------------------------
ПП: Видя ли специалните предложения на СуперХостинг.БГ? Ако имаш идеи за сайт, това е правилното място!
http://www.superhosting.bg/promo/spring?utm_source=MailBG&utm_medium=footer&utm_content=v2&a...
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: very slow postgresql startup
@ 2016-05-25 11:01 zz_11@mail.bg
parent: zz_11@mail.bg
3 siblings, 1 reply; 7+ messages in thread
From: zz_11@mail.bg @ 2016-05-25 11:01 UTC (permalink / raw)
To: 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@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://www.superhosting.bg/promo/spring?utm_source=MailBG&utm_medium=footer&utm_content=v2&a...
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: very slow postgresql startup
@ 2016-05-25 11:04 Vicky Soni - Quipment India <vicky.soni@quipment.nl>
parent: zz_11@mail.bg
0 siblings, 0 replies; 7+ messages in thread
From: Vicky Soni - Quipment India @ 2016-05-25 11:04 UTC (permalink / raw)
To: zz_11@mail.bg <zz_11@mail.bg>; pgsql-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...;
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: very slow postgresql startup
@ 2016-05-30 16:29 Alex Ignatov <a.ignatov@postgrespro.ru>
parent: zz_11@mail.bg
3 siblings, 0 replies; 7+ messages in thread
From: Alex Ignatov @ 2016-05-30 16:29 UTC (permalink / raw)
To: zz_11@mail.bg; pgsql-admin
On 23.05.2016 11:33, zz_11@mail.bg wrote:
>
> 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...;
Hi!
What do you see in strace output? I think that pg falls in unlinking
temp file from previous incarnation. Check this out or show us strace
output.
Thank you in advance.
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2016-05-30 16:29 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-05-23 08:33 very slow postgresql startup zz_11@mail.bg
2016-05-23 09:19 ` Venkata Balaji N <nag1010@gmail.com>
2016-05-23 09:28 ` Magnus Hagander <magnus@hagander.net>
2016-05-23 09:49 ` zz_11@mail.bg
2016-05-25 11:01 ` zz_11@mail.bg
2016-05-25 11:04 ` Vicky Soni - Quipment India <vicky.soni@quipment.nl>
2016-05-30 16:29 ` Alex Ignatov <a.ignatov@postgrespro.ru>
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