[ARCHIVED] future scalability of the service?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2015
04:05 PM
One of our tables, requests, has over 1,000,000,000 rows in it. Since redshift doesn't support indexes, it's a very cumbersome table to work with.
What is the plan for scale in the future?
Solved! Go to Solution.
1 Solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2015
11:25 AM
Patrick,
How would you like to use this data. We are considering exporting a few rollups that will be easier to deal with. We would love to hear from you and others on what kind of rollups make sense.
We will also be adding columns for year, month, quarter, day which should make the table more approachable and allow Redshift's columnar architecture to better query the data.