On Thu, Mar 8, 2018 at 11:45 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Prabhat Sahu <prabhat.s...@enterprisedb.com> writes: >> On Wed, Mar 7, 2018 at 7:51 PM, Robert Haas <robertmh...@gmail.com> wrote: >>> That looks like the background worker got killed by the OOM killer. How >>> much memory do you have in the machine where this occurred? > >> I have ran the testcase in my local machine with below configurations: >> Environment: CentOS 7(64bit) >> HD : 100GB >> RAM: 4GB >> Processor: 4 > > If you only have 4GB of physical RAM, it hardly seems surprising that > trying to use 8GB of maintenance_work_mem would draw the wrath of the > OOM killer.
Yup. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company