[ARCHIVED] future scalability of the service?

Jump to solution
pmichaud
Community Novice

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?

Labels (1)
1 Solution
msmith
Instructure Alumni
Instructure Alumni

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.

View solution in original post