Redshift Observatory

Blog

https://www.redshift-observatory.ch/slblog/2021-04.html

2021-04-26 : Introduction and Welcome

https://www.redshift-observatory.ch/slblog/2021-06.html

2021-06-08 : Update

https://www.redshift-observatory.ch/slblog/2021-07.html

2021-07-06 : Update

https://www.redshift-observatory.ch/slblog/2021-08.html

2021-08-09 : Update
2021-08-17 : And We’re Live
2021-08-19 : Unsorted Tables
2021-08-20 : Temp Tables and K-Safety
2021-08-23 : Update
2021-08-25 : Work In Progress

https://www.redshift-observatory.ch/slblog/2021-09.html

2021-09-03 : AWS Bill
2021-09-06 : Materialized Views
2021-09-15 : System Table Explorer Update
2021-09-17 : RA3 Investigation
2021-09-18 : Auto-Vacuum
2021-09-19 : Amazon Redshift Cluster Toolkit AMI
2021-09-21 : New Data Types for Time
2021-09-25 : Replacement System Tables
2021-09-29 : Text Formatting
2021-09-29 : Unicode

https://www.redshift-observatory.ch/slblog/2021-10.html

2021-10-01 : Redshift Improvements
2021-10-08 : CTE
2021-10-09 : octet_length()
2021-10-11 : White Paper Delayed
2021-10-11 : UNLOAD
2021-10-12 : Delayed White Paper
2021-10-12 : PRNG White Paper Update
2021-10-14 : White Paper Update
2021-10-17 : Yet Another Update
2021-10-18 : Published - Finally
2021-10-20 : Redshift Compiler Change
2021-10-20 : Version String Update / Remediation
2021-10-20 : View SQL Dump Broken
2021-10-20 : New Redshift Release
2021-10-21 : Leading Questions
2021-10-24 : Encodings
2021-10-25 : SUPER
2021-10-26 : hllsketch Dummy Data

https://www.redshift-observatory.ch/slblog/2021-11.html

2021-11-01 : AZ64 Update
2021-11-03 : Intersting…
2021-11-07 : Update
2021-11-08 : System Table Explorer Update
2021-11-14 : Update
2021-11-20 : Update
2021-11-23 : Update
2021-11-29 : Update

https://www.redshift-observatory.ch/slblog/2021-12.html

2021-12-01 : Server-less Redshift
2021-12-04 : New White Paper
2021-12-11 : Coronavirus
2021-12-20 : Update
2021-12-23 : Time Broken in Interleaved Tables
2021-12-24 : Interval
2021-12-26 : Telemetry
2021-12-26 : VARBYTE
2021-12-27 : Startup Failure
2021-12-30 : Loading Varbyte
2021-12-31 : User Experience.
2021-12-31 : stddev_pop() With Intervals

https://www.redshift-observatory.ch/slblog/2022-01.html

2022-01-02 : Next White Paper
2022-01-03 : Ahhhh!
2022-01-04 : T-1
2022-01-05 : VLC Delays White Paper
2022-01-06 : Query Compilation Update
2022-01-10 : Redshift Version Tracker
2022-01-13 : Update
2022-01-19 : Teaser
2022-01-23 : Redshift Reliability

https://www.redshift-observatory.ch/slblog/2022-02.html

2022-02-03 : Update
2022-02-04 : systemd Strikes Again
2022-02-11 : Prices
2022-02-13 : Near Future Work
2022-02-27 : Update

https://www.redshift-observatory.ch/slblog/2022-04.html

2022-04-12 : AUTO Sorting
2022-04-19 : Current Timestamps
2022-04-21 : extract()
2022-04-21 : Bi-Weekly Benchmarks

https://www.redshift-observatory.ch/slblog/2022-05.html

2022-05-06 : Multiple Updates
2022-05-16 : Window Function Bug
2022-05-23 : Bi-Weekly Benchmarks
2022-05-27 : System Table Tracker

https://www.redshift-observatory.ch/slblog/2022-06.html

2022-06-09 : Bi-Weekly Cross-Region Benchmark Results
2022-06-24 : Bi-Weekly Cross-Region Benchmark Results

https://www.redshift-observatory.ch/slblog/2022-07.html

2022-07-07 : Bi-Weekly Cross-Region Benchmark Results
2022-07-24 : Updates
2022-07-28 : Coming to Kyiv
2022-07-30 : Day 1 (Saturday)

https://www.redshift-observatory.ch/slblog/2022-08.html

2022-08-07 : Static and Dynamic Column Ordinals in System Tables
2022-08-07 : Kyiv Week Two
2022-08-08 : System Table Functions
2022-08-10 : Real-Time Video of a Table Being VACUUMed
2022-08-11 : ATMs
2022-08-12 : Signs of War
2022-08-15 : Kyiv Photos and Audio
2022-08-20 : Minor Update
2022-08-23 : Air Raid Warnings
2022-08-24 : Independence Day
2022-08-27 : Query Compilation
2022-08-28 : Updates

https://www.redshift-observatory.ch/slblog/2022-09.html

2022-09-10 : Update
2022-09-19 : Amazon Redshift Bi-Weekly Weather Report #16
2022-09-22 : AQUA
2022-09-29 : Butcha

https://www.redshift-observatory.ch/slblog/2022-10.html

2022-10-10 : Missile Strikes on Kyiv
2022-10-10 : Photos
2022-10-12 : Visiting Two New Craters In Kyiv
2022-10-14 : Redshift Real-Time Query Monitoring
2022-10-17 : More Missile Strikes
2022-10-17 : Witnessed a Missile Strike
2022-10-20 : Living Without Electricity in Kyiv
2022-10-20 : First Power Cut Today in Kyiv
2022-10-31 : Missile/Drone Strikes On Kyiv City Now

https://www.redshift-observatory.ch/slblog/2022-11.html

2022-11-04 : Max Ganz’s Redshift Combubulator First Light
2022-11-04 : Amazon Redshift Weather Report
2022-11-07 : New Banksy In Kyiv
2022-11-17 : Update
2022-11-23 : Amazon Redshift Bi-Weekly Weather Report
2022-11-23 : Recursive CTEs
2022-11-24 : Graphing Dependencies

https://www.redshift-observatory.ch/slblog/2022-12.html

2022-12-02 : Amazon Redshift Weather Report
2022-12-03 : Compilation Information In The System Tables
2022-12-05 : Robust ETL Design and Implementation for Amazon Redshift
2022-12-19 : Weather Report
2022-12-29 : Queries in the System Tables
2022-12-29 : Explosions
2022-12-29 : Views
2022-12-31 : Major Ongoing Missile Strikes In Kyiv

https://www.redshift-observatory.ch/slblog/2023-01.html

2023-01-02 : VACUUM
2023-01-02 : Quiet Night
2023-01-06 : Amazon Redshift Weather Report
2023-01-07 : Materialized Views
2023-01-15 : Roles in Amazon Redshift
2023-01-15 : Топлений Шоколад
2023-01-16 : Further Thoughts On Roles
2023-01-16 : Undocumented System Privs
2023-01-16 : Alarm Bells
2023-01-21 : Amazon Redshift Weather Report
2023-01-23 : Late Binding Views
2023-01-27 : System Table Tracker

https://www.redshift-observatory.ch/slblog/2023-02.html

2023-02-01 : 1m 50s Of Annotated Air Defence Footage From Kyiv
2023-02-01 : New White Paper : Users, Groups, Roles and Privileges
2023-02-01 : Amazon Redshift Weather Report
2023-02-13 : Max Ganz’s Redshift Combobulator!
2023-02-17 : Weather Report
2023-02-17 : Insider View on an AWS Big Data Blog Post
2023-02-20 : WW2 Memorial, Kyiv
2023-02-25 : Node Performance Variation

https://www.redshift-observatory.ch/slblog/2023-03.html

2023-03-02 : System Table Tracker
2023-03-04 : Weather Report
2023-03-09 : Missile Attacks This Morning in Kyiv
2023-03-09 : varbyte sorting
2023-03-09 : Sheltering from Missile Attacks
2023-03-11 : IAM
2023-03-15 : New Version Rolled Back (and Diffs!)
2023-03-21 : Site Domain Name Change
2023-03-21 : Weather Report
2023-03-26 : EXPLAIN
2023-03-26 : VACUUM Requirement for Merge Joins

https://www.redshift-observatory.ch/slblog/2023-04.html

2023-04-01 : System Table Tracker Function Diffs
2023-04-02 : Stuff
2023-04-05 : Four New Regions
2023-04-06 : Mystery of The Missing System Tables
2023-04-07 : New White Paper
2023-04-11 : Weather Report
2023-04-18 : Weather Report
2023-04-23 : New PDF : MERGE
2023-04-23 : First Guesses about Amazon Redshift Serverless
2023-04-27 : Second version of MERGE published
2023-04-30 : Something Odd Is Happening
2023-04-30 : Two New Redshift Versions

https://www.redshift-observatory.ch/slblog/2023-05.html

2023-05-01 : Redshift Internal System Table Access Control Mechanism
2023-05-02 : Cluster Bring Up Behaviour
2023-05-03 : System Table Tracker
2023-05-05 : Weather Report
2023-05-06 : Redshift Serverless
2023-05-08 : Serverless
2023-05-08 : Serverless Update
2023-05-09 : New Redshift Version
2023-05-13 : Update
2023-05-13 : Update
2023-05-13 : System Table Tracker Bug Fix
2023-05-14 : Update
2023-05-19 : Weather Report
2023-05-21 : Update
2023-05-21 : AHHHHHHHH
2023-05-21 : Mmmm
2023-05-28 : Serverless PDF Update
2023-05-29 : Redshift Servrerless First Numbers
2023-05-29 : AutoWLM Admin Queue?
2023-05-29 : AutoWLM Slots
2023-05-29 : More Fun With AutoWLM
2023-05-29 : More AutoWLM
2023-05-30 : boto3 / Living Hell
2023-05-31 : Serverless Update

https://www.redshift-observatory.ch/slblog/2023-06.html

2023-06-01 : Update
2023-06-05 : Update
2023-06-06 : Weather Report
2023-06-13 : Redshift Rollback
2023-06-18 : Two New Redshift Versions
2023-06-19 : The Ukrainian Summer Offensive 2023
2023-06-24 : Curious Events in Russia
2023-06-26 : Update
2023-06-27 : Belated Weather Report

https://www.redshift-observatory.ch/slblog/2023-07.html

2023-07-05 : Weather Report
2023-07-05 : LVM - Hit and Bounced
2023-07-12 : Cluster Munitions
2023-07-15 : Weather Report
2023-07-27 : Text Mangling in Procedures
2023-07-29 : The Ukrainian Offensive

https://www.redshift-observatory.ch/slblog/2023-08.html

2023-08-01 : Weather Report
2023-08-02 : XFCE
2023-08-05 : Redshift Bulletin
2023-08-07 : New Forum (and Mailing List)
2023-08-16 : Weather Report
2023-08-16 : New Redshift release, version 1.0.54899
2023-08-16 : Mailing List
2023-08-22 : Combobulator
2023-08-27 : Max Ganz’s Redshift Combobulator is now GA
2023-08-31 : Combobulator Trial for Publicly Accessible Clusters

https://www.redshift-observatory.ch/slblog/2023-09.html

2023-09-01 : Weather Report
2023-09-15 : Weather Report
2023-09-16 : STV_SESSIONS
2023-09-17 : Sorting, Skew and The Zone Map
2023-09-21 : System Table Views Using Functions
2023-09-25 : External Tables
2023-09-27 : System Table Data Bug
2023-09-30 : PDF : Amazon Redshift Serverless
2023-09-30 : r/AmazonRedshift banned on Reddit
2023-09-30 : Reddit Account Banned

https://www.redshift-observatory.ch/slblog/2023-10.html

2023-10-03 : Weather Report
2023-10-04 : Correction : Amazon Redshift Serverless
2023-10-13 : AirGradient
2023-10-15 : Weather Report
2023-10-17 : Manchester Airport, UK
2023-10-31 : UK Trains

https://www.redshift-observatory.ch/slblog/2023-11.html

2023-11-04 : Weather Report
2023-11-10 : System Table Tracker Bugfix
2023-11-12 : System Table Tracker One Page Diff
2023-11-19 : ra3 Nodes Unavailable in us-east-1 and -us-west-2
2023-11-25 : Slovakia and Putin’s Influence in Western Elections
2023-11-28 : System Table Tracker

https://www.redshift-observatory.ch/slblog/2023-12.html

2023-12-01 : Weather Report
2023-12-02 : Differentiating Leader Nodes and Worker Nodes
2023-12-05 : Compute Slices PDF
2023-12-07 : RUSI Article
2023-12-10 : ra3 Bring-Up Problems
2023-12-10 : dc2 Bring-Up Problems
2023-12-11 : New PDF OTW : Late-Binding Views
2023-12-15 : Late-Binding Views (PDF)
2023-12-30 : 1.0.61395 is out

https://www.redshift-observatory.ch/slblog/2024-01.html

2024-01-06 : Weather Report
2024-01-12 : Rollback Affecting 16mb SUPER
2024-01-15 : Web-Site Server Move
2024-01-16 : New STV_RECENTS Issues
2024-01-18 : Weather Report

https://www.redshift-observatory.ch/slblog/2024-02.html

2024-02-07 : Problems Rolling Out 16mb SUPER
2024-02-07 : Weather Report (belated - for 2024-02-02)

https://www.redshift-observatory.ch/slblog/2024-03.html

2024-03-02 : Weather Report
2024-03-05 : Dental Filling without Anaesthetic
2024-03-29 : Weather Report

https://www.redshift-observatory.ch/slblog/2024-04.html

2024-04-04 : Weather Report
2024-04-07 : Cross-Region Benchmarks as Gnuplots
2024-04-19 : Redshift Version Tracker Improvement
2024-04-22 : Problems With New RS Version, 1.0.66954
2024-04-23 : Trailing Track

https://www.redshift-observatory.ch/slblog/2024-05.html

2024-05-04 : MIME Considered Harmful
2024-05-07 : End of the Road for Apache
2024-05-07 : Snapshot Isolation
2024-05-09 : ANALYZE
2024-05-14 : COPY
2024-05-15 : More COPY
2024-05-16 : SQA
2024-05-18 : UNLOAD
2024-05-19 : PSA : AQUA Has Become Mandatory
2024-05-20 : I’m afraid I must retract one of the earlier claims about UNLOAD.
2024-05-28 : Strange Goings-On In The Land of Version Numbers
2024-05-30 : STL_COMMIT_STATS

https://www.redshift-observatory.ch/slblog/2024-06.html

2024-06-15 : Merge Join
2024-06-15 : More on Merge Join
2024-06-19 : Materialization
2024-06-19 : So I want to write a bit about concrete examples for the previous post, about materialization.
2024-06-19 : ANALYZE Matters
2024-06-29 : Deep Copy

https://www.redshift-observatory.ch/slblog/2024-07.html

2024-07-06 : STV_BLOCKLIST and NULL
2024-07-06 : STV_BLOCKLIST and NULLs (part two)
2024-07-07 : Putin’s War
2024-07-08 : Mainstream Reporting
2024-07-19 : VACUUM
2024-07-19 : eu-north-1
2024-07-25 : ANALYZE
2024-07-26 : VACUUM Boost Option
2024-07-27 : Elastic Downsize
2024-07-27 : More Elastic Downsizing

https://www.redshift-observatory.ch/slblog/2024-08.html

2024-08-16 : SYS_TRANSACTION_HISTORY
2024-08-17 : Minor Pandoc Vent
2024-08-24 : STL “Tables”
2024-08-29 : Serverless
2024-08-29 : SYS_QUERY_HISTORY
2024-08-30 : More on SYS views
2024-08-31 : New Node and Elastic Resize

https://www.redshift-observatory.ch/slblog/2024-09.html

2024-09-05 : STL_VACUUM
2024-09-05 : SYS_VACUUM_HISTORY
2024-09-10 : STL_QUERYTEXT
2024-09-12 : Benchmarking Queries
2024-09-23 : Result Cache
2024-09-25 : Queuing Discovery
2024-09-28 : CTEs
2024-09-30 : Comments on The War

https://www.redshift-observatory.ch/slblog/2024-10.html

2024-10-11 : ra3.xlplus local disk and stv_partitions
2024-10-12 : ra3.large
2024-10-13 : Leader-Node Views Considered Faster
2024-10-19 : A Bit More On The War
2024-10-24 : Elections in Moldova
2024-10-27 : Layered Views
2024-10-30 : Interval
2024-10-31 : sf.copy_errors

https://www.redshift-observatory.ch/slblog/2024-11.html

2024-11-02 : K-Safety
2024-11-05 : Privacy Package
2024-11-05 : bill.com
2024-11-07 : Commit Queue

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers