On Mon, Jan 27, 2020 at 5:27 AM Ron <ronljohnsonjr@xxxxxxxxx> 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
- 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)
