0

I have a Heroku database ($200 plan). THe database is quite simple: it contains user clicks. There are about 10 fields in the main table, some fields are indexed, and the table contains about several hundred million rows currently.

The main select query is - searching by indexed field (click ID). It is quite fast, as an indexed query should be.

My main concern is database growth. The database is currently 250GB in size, and it keeps increasing. Every month it grows by 25 GB.

Will there be a limit when the DB slows down and I will have to do something about it (partitioning etc)? What will this limit look like? 1TB? 10TB? 100 TB?

enter image description here

Improve this question
3
  • 2
    That depends on your query and its execution plan. You might want to partition so that you can get rid of old data. Commented Feb 21, 2023 at 8:16
  • yes but what if I dont? When will it create problems? Commented Feb 24, 2023 at 14:28
  • Perhaps. That depends on your queries and their execution plans. Commented Feb 24, 2023 at 14:31
Related questions
2
How to save entire Scrollable canvas as Png
1
How can I capture a drawing of a panel in winform to bitmap and save it to SQL database?
9
Save canvas to bitmap
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.