On Mon, Jan 27, 2020 at 5:27 AM Ron <ronljohnso...@gmail.com> wrote: > 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. > > *Sandip - Few questions not sure how your scripts are setup. To speed up things faster , are you *
1. *providing work_mem and maintenance_work_mem parameters while creating the indexes. ? ( If Not I would highly recommend to set maintenance_work_mem to 8 -10 GB if your cluster has enough memory)*
