Search Postgresql Archives
Need support on tuning at the time of index creation
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: Need support on tuning at the time of index creation
- From: Sandip Pradhan <sandip.pradhan@xxxxxxxxxxxx>
- Date: Mon, 27 Jan 2020 11:10:36 +0000
- Accept-language: en-US
- Cc: Ravi Sharan <ravi.sharan@xxxxxxxxxxxx>, Amit Kumar TT <amit.tt.kumar@xxxxxxxxxxxx>
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.
Thanks & Regards,
Sandip Pradhan
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]