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

Hi Ron,

Thanks for your time.

We are using the version 9.5.9.14.

Regards,

 
Sandip Pradhan
Tech Lead
 
BDGS SD IN BSS EOC_ECM 1
Mobile: 9830880856
sandip(dot)pradhan(at)ericsson(dot)com
 
Ericsson
DLF IT Park - II, DLF SEZ Block 1A, Rajarhat
700156, Kolkata, West Bengal
India
ericsson.com

-----Original Message-----
From: Ron <ronljohnsonjr(at)gmail(dot)com>
Sent: Monday, January 27, 2020 4:57 PM
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Need support on tuning at the time of index creation

On 1/27/20 5:10 AM, Sandip Pradhan wrote:
> Dear Sir/Madam,
>
> One of our ericsson product used backend db as postgresql 9. We are
> facing following performance issues where we need some support from your side.
> We are having 10 tables and we are inserting around 150 million to 250
> million records on each of those tables. After that we need to create
> 29 indexes includung primary key index and other types of indexes.
> Currently it is taking almost 3.5 to 4 hrs.
>
> Please let us know how we can tune the perfirmance so that we can
> complete this task in 30-40 mins.
>
> Note: We cannot change the db version.

There are seven versions of "postgresql 9", and multiple patch releases of each.  Please specify which version you're running.

--
Angular momentum makes the world go 'round.