Timeline for Most efficient way of bulk deleting rows from postgres
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 23, 2020 at 20:38 | comment | added | Kenny Evitt | In case anyone else doesn't know (like I did until recently), disabling or deleting triggers (which PostgreSQL uses internally for constraints too) can improve the performance of bulk deletions by several orders of magnitude. Given that the original question mentions recurring (daily) bulk imports, I imagine that was being done for the relevant tables already. | |
| Oct 29, 2018 at 23:56 | answer | added | Niro | timeline score: 8 | |
| Jun 22, 2015 at 14:21 | comment | added | Simon | The same question has been answered in more detail here: stackoverflow.com/a/8290958 | |
| Feb 19, 2013 at 10:37 | answer | added | Chris Travers | timeline score: 42 | |
| Feb 17, 2013 at 1:17 | history | tweeted | twitter.com/#!/StackDBAs/status/302949922309799938 | ||
| Feb 16, 2013 at 17:43 | history | asked | tarnfeld | CC BY-SA 3.0 |