3 ms·
A 40% reduction would be 600GB, and an index that took up 40% of the total would be excessive/unrealistic as well. You're right of course that Postgres lacks t
by ttfkam 4y ago
A 40% reduction would be 600GB, and an index that took up 40% of the total would be excessive/unrealistic as well.
You're right of course that Postgres lacks true clustered indexes. The closest thing it has is covering indexes, which don't help at all with saving space; quite the opposite in fact.
- srcreigh 4y agoThanks. You’re right. And yeah, the 40% ish reduction would only happen if the table has for ex every column in a unique index. Not very common.