Timeline for answer to How to speed up insertion performance in PostgreSQL by Denys
Current License: CC BY-SA 4.0
Post Revisions
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 18, 2023 at 21:24 | comment | added | Sergey Kuznetsov | You don't have to drop the primary key, as there is another solution: partitions. If you will create partitioned table, in that case you will have smaller indexes per partition, and because of that insertion speed will be high. Also it simplifies and speed up the deletion of the old data. | |
| Oct 9, 2021 at 10:03 | comment | added | PainIsAMaster | @Dennis so the table you are joining on or grabbing data from doesn't matter, only the table you INSERT INTO? I definitely just tried this and it is much faster WOW thanks | |
| Sep 27, 2021 at 10:36 | comment | added | Anand Tripathi | This helped me a lot | |
| Feb 28, 2019 at 16:24 | history | edited | Denys | CC BY-SA 4.0 |
edited body
|
| Aug 10, 2018 at 23:19 | history | answered | Denys | CC BY-SA 4.0 |