RE: Need support on tuning at the time of index creation

[Sandip Pradhan <sandip.pradhan@xxxxxxxxxxxx>]

Currently maintenance_work_mem set to 25 GB.

 

Regards,

 

 

Sandip Pradhan

Tech Lead

 

BDGS SD IN BSS EOC_ECM 1

Mobile: 9830880856

sandip.pradhan@xxxxxxxxxxxx

 

Ericsson

DLF IT Park - II, DLF SEZ Block 1A, Rajarhat

700156, Kolkata, West Bengal

India

ericsson.com

 

From: Jayadevan M <maymala.jayadevan@xxxxxxxxx>
Sent: Friday, January 31, 2020 3:30 PM
To: Sandip Pradhan <sandip.pradhan@xxxxxxxxxxxx>
Cc: Ron <ronljohnsonjr@xxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxxxxxxxx
Subject: Re: Need support on tuning at the time of index creation

 

 

 

On Fri, Jan 31, 2020 at 3:22 PM Sandip Pradhan <sandip.pradhan@xxxxxxxxxxxx> 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