Re: [GENERAL] startup process stuck in recovery

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: [GENERAL] startup process stuck in recovery
Дата
Msg-id CANP8+jLQOv7pSifvTM6uf7Xe9hnKs4u5a1fv+xssctBCwOCn5g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] startup process stuck in recovery  (Christophe Pettus <xof@thebuild.com>)
Ответы Re: [GENERAL] startup process stuck in recovery  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On 11 October 2017 at 08:09, Christophe Pettus <xof@thebuild.com> wrote:
>
>> On Oct 10, 2017, at 23:54, Simon Riggs <simon@2ndQuadrant.com> wrote:
>>
>> The use case described seems incredibly
>> unreal and certainly amenable to being rewritten.
>
> While it's certainly true that this was an extreme case, it was a real-life production situation.  The concern here
isthat in the actual production situation, the only symptom was that the startup process just stopped.  There were no
logmessages or any other indication of what was going wrong. 

Which indicates it was making progress, just slowly.

Tom says "This is pretty easy to diagnose though
because it spews "out of shared memory" WARNING messages to the
postmaster log at an astonishing rate"

These don't seem to match.

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: [GENERAL] Why does increasing the precision of a numeric column rewrites thetable?
Следующее
От: Seamus Abshere
Дата:
Сообщение: [GENERAL] Determine size of table before it's committed?