Re: [PERFORM] Slow Index Creation, why is it not consuming more memory.

2015-12-07 Thread Peter Geoghegan
On Mon, Dec 7, 2015 at 10:36 PM, Tory M Blue wrote: > What am I not understanding missing? Yes. There is a hard limit on the number of tuples than can be sorted in memory prior to PostgreSQL 9.4. It's also the case that very large work_mem or maintenance_work_mem settings are unlikely to help unl

[PERFORM] Slow Index Creation, why is it not consuming more memory.

2015-12-07 Thread Tory M Blue
Just trying to figure something out. 9.3.4, CentOS6.5 256GB Ram Maintenance_work_mem = 125GB Effective_Cache = 65GB I have 2 indexes running, started at the same time, they are not small and one will take 7 hours to complete. I see almost zero disk access, very minor, not what I want to see whe