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

From: Sandip Pradhan <sandip(dot)pradhan(at)ericsson(dot)com>
To: Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: Need support on tuning at the time of index creation
Date: 2020-01-31 10:14:12
Message-ID: VI1PR07MB4912BA220E577AAED8F3CE4CE6070@VI1PR07MB4912.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Currently maintenance_work_mem set to 25 GB.

Regards,

[cid:image002(dot)png(at)01D5D84D(dot)47F72BC0]<http://www.ericsson.com/>

Sandip Pradhan
Tech Lead

BDGS SD IN BSS EOC_ECM 1
Mobile: 9830880856
sandip(dot)pradhan(at)ericsson(dot)com<mailto:sandip(dot)pradhan(at)ericsson(dot)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(dot)jayadevan(at)gmail(dot)com>
Sent: Friday, January 31, 2020 3:30 PM
To: Sandip Pradhan <sandip(dot)pradhan(at)ericsson(dot)com>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>; pgsql-general(at)lists(dot)postgresql(dot)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(dot)pradhan(at)ericsson(dot)com<mailto:sandip(dot)pradhan(at)ericsson(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Durumdara 2020-01-31 13:43:41 Re: Add column with default value in big table - splitting of updates can help?
Previous Message Sandip Pradhan 2020-01-31 10:13:20 RE: Need support on tuning at the time of index creation