跳至内容
使用AWS re:Post即您表示您同意 AWS re:Post 使用条款
AWS re:Postre:Post
关于 re:Post

Should ADD COLUMN in Redshift be slow?

0

I have a Redshift table with approx. 25 million records. I need to add a new column to it using ALTER TABLE ... ADD COLUMN ... but I'm finding this to be very slow.

Given RS is a columnar database, I would have expected this to be very quick. Is this a correct assumption, or not?

主题
分析
标签
亚马逊 Redshift
语言
English

已提问 2 年前582 查看次数

1 回答
0

Hello, Yes , adding a new null column to a columnar database is relatively fast . Have you already tried to do this operation and its slow ? If so , can you please look into the perfomance metrics of the database

AWS

已回答 2 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈，并能促进提问者的职业发展。

相关内容