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