| From: | "Godfrin, Philippe E" <Philippe(dot)Godfrin(at)nov(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Inserts and bad performance |
| Date: | 2021-11-24 19:15:31 |
| Message-ID: | SA0PR15MB3933E7B425ADC5DC36D9A8CC82619@SA0PR15MB3933.namprd15.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Greetings
I am inserting a large number of rows, 5,10, 15 million. The python code commits every 5000 inserts. The table has partitioned children.
At first, when there were a low number of rows inserted, the inserts would run at a good clip - 30 - 50K inserts per second. Now, after inserting oh say 1.5 Billion rows, the insert rate has dropped to around 5000 inserts per second. I dropped the unique index , rebuilt the other indexes and no change. The instance is 16 vcpu and 64GB ram.
I'm perplexed, I can't see to find any reason for the slow down...
Thanks,
pg
Phil Godfrin | Database Administration
NOV
NOV US | Engineering Data
9720 Beechnut St | Houston, Texas 77036
M 281.825.2311
E Philippe(dot)Godfrin(at)nov(dot)com<mailto:Philippe(dot)Godfrin(at)nov(dot)com>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenneth Marshall | 2021-11-24 19:20:10 | Re: Inserts and bad performance |
| Previous Message | Aleš Zelený | 2021-11-24 17:51:57 | Re: RPM package issue |