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.pradhan@xxxxxxxxxxxx Ericsson DLF IT Park - II, DLF SEZ Block 1A, Rajarhat 700156, Kolkata, West Bengal India ericsson.com -----Original Message----- From: Ron <ronljohnsonjr@xxxxxxxxx> Sent: Monday, January 27, 2020 4:57 PM To: pgsql-general@xxxxxxxxxxxxxxxxxxxx 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.
