Re: Possible Corrputed shared memory

James Sebastian <james(dot)sebastian(at)gmail(dot)com> writes:
> On 1 August 2015 at 19:43, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Also, if it took that long to recover, you might have raised the
>> checkpoint interval settings too high.

> I am using the following parameters

> checkpoint_segments = 10 (from OS default 3)
> checkpoint_completion_target = 0.8 (from OS default 0.5)
> archive_mode=on
> archive_timeout=600

[ scratches head... ] It should certainly not have taken very long to
replay 10 WAL segments worth of data. I surmise that the problems
you were having before the shutdown were worse than you thought, ie
checkpoints were failing to complete, probably due to a persistent
I/O error, so that there was a whole lot more than normal to replay
after the last successful checkpoint. Is there any evidence of such
distress in the postmaster log?

regards, tom lane