Should ADD COLUMN in Redshift be slow?


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?

asked 10 days ago107 views
1 Answer

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

answered 10 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions