Postgres Pro
Downloads
Home   >   mailing lists

RE: Need support on tuning at the time of index creation - Mailing list pgsql-general

From Sandip Pradhan
Subject RE: Need support on tuning at the time of index creation
Date
Msg-id VI1PR07MB4912BA220E577AAED8F3CE4CE6070@VI1PR07MB4912.eurprd07.prod.outlook.com
Whole thread Raw
In response to Re: Need support on tuning at the time of index creation  (Jayadevan M <maymala.jayadevan@gmail.com>)
List pgsql-general
Tree view

Currently maintenance_work_mem set to 25 GB.

 

Regards,

 

 

Sandip Pradhan

Tech Lead

 

BDGS SD IN BSS EOC_ECM 1

Mobile: 9830880856

sandip.pradhan@ericsson.com

 

Ericsson

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

700156, Kolkata, West Bengal

India

ericsson.com

 

From: Jayadevan M <maymala.jayadevan@gmail.com>
Sent: Friday, January 31, 2020 3:30 PM
To: Sandip Pradhan <sandip.pradhan@ericsson.com>
Cc: Ron <ronljohnsonjr@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.pradhan@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

 

Attachment

pgsql-general by date:

Previous
From: Sandip Pradhan
Date:
Subject: RE: Need support on tuning at the time of index creation
Next
From: Durumdara
Date:
Subject: Re: Add column with default value in big table - splitting of updatescan help?