|
|
|
|
|
|
by da_chicken
779 days ago
|
|
|
If I'm creating a backup table -- as in, I'm going to do some complex nebulous operation that might screw up in ways I don't immediately foresee -- then I don't care at all about indexes or constraints. I want an immediately present copy of the data that I plan to never need but is there so I don't have to restore from DB backup + WAL. Creating the indexes is a waste of both server time and disk space. If something goes pear-shaped or I really need them, I can create those indexes later. |
|
|