跳至內容
使用 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?

主題
分析
標籤
Amazon 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 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋，同時有助於提問者的專業成長。

相關內容