[Info-ingres] Compression weighs heavy on my defaults.
Roy Hann
specially at processed.almost.meat
Tue Oct 17 09:58:13 UTC 2017
Paul White wrote:
> I avoid alter table .. add column.
Bath-water. Baby.
There are "best practices" that should be better known (or documented)
to avoid unwelcome surprises when using ALTER TABLE...ADD COLUMN.
Testing prior to release into live is always prudent. Surprises during
testing are acceptable (to me). Every day is a school day.
Even so, we should expect ALTER TABLE to give identical results
whether using compression or not.
The other thing that puzzled me about Marty's example is that
non-HIDATA compression isn't expected to do anything to integers.
Roy
More information about the Info-ingres
mailing list