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
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