Timeline for Changing POSTGRES column datatype - should I drop indexes and then re-create?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 20 at 17:51 | comment | added | jjanes | @dantiberian The column type change being described involves the entire table being rewritten (and the layout changing since the new rows will be a different size). That inherently involves rebuilding all of the indexes, as all of the old indexes will be pointing into storage that no longer exists. | |
| S Nov 20 at 16:44 | history | suggested | dantiberian | CC BY-SA 4.0 |
Update link, change to point to exact section of the docs, include quote about running ANALYZE
|
| Nov 20 at 0:49 | review | Suggested edits | |||
| S Nov 20 at 16:44 | |||||
| Nov 20 at 0:48 | comment | added | dantiberian | Are you sure that all of the indexes on the table will be dropped, and not just the indexes that contain the column? The docs say only the indexes involving the column will be converted. | |
| S Aug 3, 2021 at 14:08 | history | suggested | LondonRob | CC BY-SA 4.0 |
Added reference to the docs
|
| Aug 3, 2021 at 13:18 | review | Suggested edits | |||
| S Aug 3, 2021 at 14:08 | |||||
| Sep 18, 2019 at 7:05 | vote | accept | ConanTheGerbil | ||
| Sep 17, 2019 at 18:39 | history | answered | jjanes | CC BY-SA 4.0 |