Hello I can't add a column to database, it seems ...
# sql
o
Hello I can't add a column to database, it seems like there is not enough disk space, the table size is about 2GB, so 4GB should be enough for the migration but I receive error that disk space is not enough. Here is the query and error:
Copy code
postgres=> ALTER TABLE "blocks" ADD COLUMN "textSearch" TSVECTOR GENERATED 
ALWAYS AS (to_tsvector('english', text)) STORED;
ERROR:  could not extend file "base/12974/446445": No space left on device
HINT:  Check free disk space.
b
Did you file a support ticket on this? I think I already increased your disk space and responded to this.
o
Yes, This is resolved now, thank you
This is unrelated But previously in discord I asked what this means and didn't get answer

https://media.discordapp.net/attachments/839993398554656831/974321440415432804/Screenshot_2022-05-12_at_15.45.26.png

b
It looks like it took more disk space to do the alter table.
I believe that graph is related to EBS I/O Balance. See: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-io-characteristics.html
o
Thanks