[andatki]

Really solid list! I went through all the Active Record, query design, and index design tips for PostgreSQL, and can +1 them all. Nice work.

For readers who want all of these and more in book form, with a sample Rails app and big data to test with (generated), please consider my book:

High Performance PostgreSQL for Rails https://news.ycombinator.com/item?id=38407585

The book helps readers build database skills with the overall purpose of improved performance and scalability.

Again, great, concise article. I’ll be recommending it to others and it will help a lot of developers!

Thanks!

[a12b]

Thanks. I bought your book since the B1.0 version and I recommend it.

[andatki]

Thank you! Beta book period is nearly wrappped up!

[Vayl]

Awesome, thanks for plugging this here! Exactly the kind of material I was looking for :)

[andatki]

Great! I wasn’t sure whether to plug it but it seemed very relevant to the post. :)