Re: Invoke OOM killer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


On Thu, Jul 6, 2023 at 12:27 PM kaido vaikla <kaido.vaikla@xxxxxxxxx> wrote:

How to invoke OOM killer for pg process?
Some easy "hack" for test purpose.

For most purposes, you can just pick a backend process ID, and send it a `kill -9`.  From the PostgreSQL perspective, that is just what the OOM killer does. 

If it needs to happen 'naturally', you could do something like:

set work_mem=50GB;
select * from generate_series(1,100000000) order by random();

Where the numbers may need to be adjusted based on your RAM.



[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux