Hi all...i have the following problem:
have several big tables (approximately 40 columns, 50 mil. rows)
and ther is one column called version which is int8 (version int8). There are only
null values in this column.
And i want to do following:
update bigtable set version=1;
The problem is that during this update i run out of my disk space.
Can someone explain me how is this possible? I was thinking that when i have allocated some space for integer column, there is no need for additional space when i want to update the value in this column.