SCHEMA and DATABASE statements process tables ordered by raw size ascending
Details
| Detail name | Value |
|---|---|
| Changelog Number | 1966 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 7.0.0, Exasol 7.0.0-alpha1 |
| Resolution Date | 2019-10-21 |
Situation
To reorganize or recompress a table you need enough free space in your storage to hold the table and its indices a second time (new version). With large tables space usage of such operations often becomes critical.
In schema and database statements like REORGANIZE DATABASE after a cluster enlargement the order of tables is undefined which leaves the risk that the operation starts with a very large table.
Improvement
By ordering tables of schema and database statements by raw size ascending we reduce the risk of a full disk to a minimum. As small tables are recompressed or reorganized the space usage on the database nodes is gradually reduced and hence the full disk scenario less likely.
