Re: 13.4 on RDS, SSL SYSCALL EOF on restore
От
Alvaro Herrera
Тема
Re: 13.4 on RDS, SSL SYSCALL EOF on restore
Дата
Msg-id
202110082248.xmzxkwo5gup7@alvherre.pgsql
Ответ на
Re: 13.4 on RDS, SSL SYSCALL EOF on restore (Alvaro Herrera)
Список
Дерево обсуждения
13.4 on RDS, SSL SYSCALL EOF on restore Wells Oliver <wells.oliver@gmail.com>
Re: 13.4 on RDS, SSL SYSCALL EOF on restore Bruce Momjian <bruce@momjian.us>
Re: 13.4 on RDS, SSL SYSCALL EOF on restore Wells Oliver <wells.oliver@gmail.com>
Re: 13.4 on RDS, SSL SYSCALL EOF on restore Tom Lane <tgl@sss.pgh.pa.us>
Re: 13.4 on RDS, SSL SYSCALL EOF on restore Wells Oliver <wells.oliver@gmail.com>
Re: 13.4 on RDS, SSL SYSCALL EOF on restore Bruce Momjian <bruce@momjian.us>
Re: 13.4 on RDS, SSL SYSCALL EOF on restore Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: 13.4 on RDS, SSL SYSCALL EOF on restore Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: 13.4 on RDS, SSL SYSCALL EOF on restore Wells Oliver <wells.oliver@gmail.com>
Re: 13.4 on RDS, SSL SYSCALL EOF on restore Ron <ronljohnsonjr@gmail.com>
On 2021-Oct-08, Alvaro Herrera wrote: > On 2021-Oct-08, Wells Oliver wrote: > > > Dug out some more logging: > > > 2021-10-08 20:35:08 UTC::@:[12682]:LOG: server process (PID 3970) was terminated by signal 9: Killed > > 2021-10-08 20:35:08 UTC::@:[12682]:DETAIL: Failed process was running: CREATE INDEX ... > > So what's happening here is that the instance is running out of RAM > while creating some index, and the kernel is killing the process. I > would probably blame the combination of shared_buffers=4GB with > maintenance_work_mem=2GB, together with the instance's total RAM. Also, maybe RDS could be smarter about this situation. -- Álvaro Herrera Valdivia, Chile — https://www.EnterpriseDB.com/ "La primera ley de las demostraciones en vivo es: no trate de usar el sistema. Escriba un guión que no toque nada para no causar daños." (Jakob Nielsen)
В списке pgsql-admin по дате отправления
