Timeline for PostgreSQL 9.5.2 DELETE taking forever
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 14, 2017 at 21:10 | vote | accept | salient | ||
| Aug 14, 2017 at 20:20 | answer | added | Emilio Platzer | timeline score: 9 | |
| Aug 14, 2017 at 19:14 | comment | added | salient | @mustaccio point taken. quick fix was to remove the fks and add them back (and the index) | |
| Aug 14, 2017 at 19:06 | comment | added | mustaccio | You may have deleted child rows, but Postgres doesn't know that and it still has to search for them. If you don't have indexes supporting foreign keys you're in for a lot of pain and suffering. | |
| Aug 14, 2017 at 18:53 | review | First posts | |||
| Aug 14, 2017 at 19:09 | |||||
| Aug 14, 2017 at 18:48 | history | asked | salient | CC BY-SA 3.0 |