Currently maintenance_work_mem set to 25 GB. Regards,
[cid:image002.png@01D5D84D.47F72BC0]<http://www.ericsson.com/> Sandip Pradhan Tech Lead BDGS SD IN BSS EOC_ECM 1 Mobile: 9830880856 sandip.prad...@ericsson.com<mailto:sandip.prad...@ericsson.com> Ericsson DLF IT Park - II, DLF SEZ Block 1A, Rajarhat 700156, Kolkata, West Bengal India ericsson.com<http://www.ericsson.com/> From: Jayadevan M <maymala.jayade...@gmail.com> Sent: Friday, January 31, 2020 3:30 PM To: Sandip Pradhan <sandip.prad...@ericsson.com> Cc: Ron <ronljohnso...@gmail.com>; pgsql-general@lists.postgresql.org Subject: Re: Need support on tuning at the time of index creation On Fri, Jan 31, 2020 at 3:22 PM Sandip Pradhan <sandip.prad...@ericsson.com<mailto:sandip.prad...@ericsson.com>> 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