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

On Mon, Jan 27, 2020 at 5:27 AM Ron <ronljohnsonjr(at)gmail(dot)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)*