How Do I Limit the Resources That Pg_dump Uses?fleeting
- External reference: https://dba.stackexchange.com/questions/192543/how-do-i-limit-the-resources-that-pg-dump-uses
How do I limit the resources that pg_dump uses?
RAM isn’t your problem. But that you’re so IO-bogged down that you can’t write to a file as a quick as you can read from the databas
pg_dump is made it work as fast as it can. If it can read data faster than it can write it, your ram usage may go up. Until the table is flushed to disk
processes don’t know how much ram a system has or how much they should take. Normally, setting a limit just does what happened here and kills the process. If it didn’t kill the process, they process may just keep drinking ram until it starts paging, and then beyond.