Hello All,<p>I have a fundamental knowledge on RDMS and have done data modelling in Postgresql (to some extend). I could able to make sense of what is Normalization, Joins, locks (specifically optimistic locking) etc.<p>I have learnt all these in my side projects mainly, or in production where the data isn't much huge. I haven't got any chance to debug a slow query or even select Indexing strategies etc which I guess is really important to understand RDMBS or postgresql in general.<p>I wanted to know are there any open source datasets, which will helpful for self studying or even debugging slow queries / seeing their indexing strategies etc.<p>Any answer would be appreciated.
See<p><a href="https://www.microsoft.com/en-us/download/details.aspx?id=52430" rel="nofollow">https://www.microsoft.com/en-us/download/details.aspx?id=524...</a><p>and other data generators for various TPC tasks. These usually have a knob you can turn to scale the size up or down.
Sakila is BSD and used on a few sites I visit: <a href="https://www.jooq.org/sakila" rel="nofollow">https://www.jooq.org/sakila</a>