![]() Add a vacuum statement (VACUUM) after each delete operation to remove ghost rows.the DELETE command uses logical deletion and since the smallest immutable blocks in Redshift use 1MB of data, it is recommended to use it wisely.Small write operations (~1 - 10 rows) have a similar cost to a larger write operation (~100K rows).Filtering / aggregating incoming data can improve performance over COPY command.Performing a lot of write operations reduces its performance, and hence it is always better to have data aggregated so as to reduce the number of writes. ![]() Remember that Redshift is designed for OLAP workloads and not OLTP. ![]() Save cluster resources for querying and reporting rather than on ELT.Load data in alternative file formats such as AWS ION, Grok, Parquet, ORC etc.Manipulate incoming column data with SQL. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |