Re: Auto-tuning work_mem and maintenance_work_mem

On 10/09/2013 01:37 PM, Peter Geoghegan wrote:
> If Heroku could increase maintenace_work_mem without having it affect
> the amount of memory used by autovacuum workers, I'm fairly confident
> that our setting would be higher. Sure, you can just increase it as
> you need to, but you have to know about it in the first place, which
> is asking too much of many people tasked with semi-routine maintenance
> tasks like creating indexes.

Personally, I never got why we used maint_work_mem instead of work_mem
for bulk-loading indexes. What was the reason there?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com