Back in 2010, I used PostgreSQL for a web app that queried 270 million rows of climate data from Environment Canada: https://www.youtube.com/watch?v=10KEr3sEG8

Back in 2010, I used PostgreSQL for a web app that queried 270 million rows of climate data from Environment Canada: https://www.youtube.com/watch?v=10KEr3sEG80 https://www.youtube.com/watch?v=10KEr3sEG80 I wanted to see how the temperature was changing over time for specific regions using a map-based interface. The following chart was particularly eye-opening: https://www.youtube.com/watch?v=iEtvf9xzRB4&t=164s https://www.youtube.com/watch?v=iEtvf9xzRB4&t=164s The software won a couple of awards and was heavily optimized to produce reports in under a minute. Kudos to the author for getting a parse time of a billion records down to mere seconds.