| 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
| 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 |