[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