Robert Haas: How Much maintenance_work_mem Do I Need? Planet PostgreSQL

While I generally like PostgreSQL’s documentation quite a bit, there are some areas where it is not nearly specific enough for users to understand what they need to do. The documentation for maintenance_work_mem is one of those places. It says, and I quote, “Larger settings might improve performance for vacuuming and for restoring database dumps,” but that isn’t really very much help, because if it might improve performance, it also might not improve performance, and…

External feed Read More at the Source: https://postgr.es/p/4kx