Re: To make pg_dump and pg_restore parallel in processing limited number of LOs

2025-05-18 Thread Tom Lane
fkfk000 writes: > However, if a user only has a limited number of LOs, like 1k, which seems > sensible as LOs should be large. In this scenario, there would be only 1 > process work. Therefore, I'm proposing a change. Instead of using a fixed > number to group LOs with same owner/ACL pair, we c

To make pg_dump and pg_restore parallel in processing limited number of LOs

2025-05-18 Thread fkfk000
Hi team, Hope you are all doing well. Recently I have encountered a scenario that a user need to dump/restore a database with 1k ~ 2k large objects. In both dump and restore process, parallel mode was used with 10 processes. However, in both dump and restore processes, it seems only 1 proces