System collects tweets from a predefined collection of Twitter accounts and keeps track of every tweet that gets deleted for analysis. Over time the system has collected over 16GB of tweets and was becoming extremely slow to query the deleted tweets. Indexing an index allows the system(Postgres DB in this case) to find the data your queries need.
1 Comment