Konubinix' opinionated web of thoughts

How Do I Limit the Resources That Pg_dump Uses?

Fleeting

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

https://dba.stackexchange.com/questions/192543/how-do-i-limit-the-resources-that-pg-dump-uses

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

https://dba.stackexchange.com/questions/192543/how-do-i-limit-the-resources-that-pg-dump-uses

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.

https://dba.stackexchange.com/questions/192543/how-do-i-limit-the-resources-that-pg-dump-uses