8

Just out of personal curiosity, how much disk space on the server does Stack Overflow take up? I'm guessing it's a lot, but I can't know for sure.

5
  • 10
    Couldn't possibly be more than around 640KB.
    – user27414
    Commented Nov 12, 2010 at 17:05
  • No no no, that's the RAM needed to run it. Commented Nov 12, 2010 at 17:34
  • I don't see this listed, but you might find more information in the sources it cites. In particular, you might note that SO is several servers. :)
    – Gnome
    Commented Nov 12, 2010 at 18:18
  • 16
    Well, each vote takes up a little more space in the database, so let's just keep upvoting this post until it runs out of disk space Commented Nov 12, 2010 at 19:52
  • 1
    The size of the datadump may serve as an approximation. Commented Nov 13, 2010 at 12:34

2 Answers 2

5

It was 12gigs compressed a few months ago, probably up to about 15gigs compressed (50 gigs uncompressed)

It is not a particularly huge database, most of the storage we have is taken up by history and indexes. Fitting most of our data in RAM is one of the reasons our performance is so awesome (that and Jeff's amazing wheel of blame).

When you look at perfmon: SQL server page life expectancy is massive, we barely go to disk.

1
  • Kudos to you Sam Saffron, creator of Discourse :) I see size is looked upon heavily and that's a good thing!
    – user965091
    Commented Aug 22, 2014 at 14:18
6

This is an ever increasing number, so no answer would be correct for long. However, you can use the Data Explorer to estimate the number. The following was accurate in the second half of August 2014.

The Data Explorer does not include the 15% of posts that are deleted (which stays in the real database) or all of the post history, so the actual database size is much higher. Thanks to to Weapon of Choice for this information.

  • This query can be used to find the size of the database tables alone (without indexes), which currently is 140 GB.

  • sp_spaceused on SEDE can be to find the database size including indexes, which currently is 186,567 MB / 1024 =182 GB.

2
  • 1
    SEDE does not contain deleted posts and much of voting and review histories. Around 15% of posts are deleted, but they remain in the database.
    – user259867
    Commented Aug 22, 2014 at 15:08
  • @900sit-upsaday Thank you, that is a good point. I updated my answer to include it.
    – dwitvliet
    Commented Aug 22, 2014 at 15:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .