Currently maintenance_work_mem set to 25 GB. Regards,
[cid:[email protected]]<http://www.ericsson.com/> Sandip Pradhan Tech Lead BDGS SD IN BSS EOC_ECM 1 Mobile: 9830880856 [email protected]<mailto:[email protected]> Ericsson DLF IT Park - II, DLF SEZ Block 1A, Rajarhat 700156, Kolkata, West Bengal India ericsson.com<http://www.ericsson.com/> From: Jayadevan M <[email protected]> Sent: Friday, January 31, 2020 3:30 PM To: Sandip Pradhan <[email protected]> Cc: Ron <[email protected]>; [email protected] Subject: Re: Need support on tuning at the time of index creation On Fri, Jan 31, 2020 at 3:22 PM Sandip Pradhan <[email protected]<mailto:[email protected]>> wrote: Hi Ron, Thanks for your time. We are using the version 9.5.9.14. May be you could try tweaking maintenance_work_mem? Regards, Jayadevan
