--- title: "How we achieved 99% Faster database queries via database indexing" url: https://daily.dev/posts/how-we-achieved-99-faster-database-queries-via-database-indexing-fmcwghq9p source_url: https://awstip.com/how-we-achieved-99-faster-database-queries-via-database-indexing-2611409d1d60?source=rss----b4c1e34ed5e---4 type: article source: "AWS Tip" published: 2022-09-23T20:52:32.559Z updated: 2022-09-23T20:52:32.495Z tags: ["database"] reading_time: 3 upvotes: 11 comments: 1 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # How we achieved 99% Faster database queries via database indexing **[AWS Tip](https://daily.dev/sources/awstip)** · 3 min read · 11 upvotes · 1 comments ## Summary 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. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Community discussion Top comments from developers on daily.dev. **@husamoli** · 0 upvotes > science! ## Similar posts on daily.dev - [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments - [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments - [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database) [View this post on daily.dev](https://daily.dev/posts/how-we-achieved-99-faster-database-queries-via-database-indexing-fmcwghq9p)