29 Jul '16, 12am

Advanced Postgres Performance Tips

You’ve added the INDEX es , both partial and covering. You’ve VACCUUM ANALYZE d. You JOIN ed and INNER JOIN ed everything to a single query. And yet, your report is still taking too long. What do you do when the low-hanging fruit has been harvested? It’s time to get down and dirty with some of the lesser known SQL constructs in Rails land. EXPLAIN what’s happening If you’ve gotten this far, you’re probably familiar with using EXPLAIN and EXPLAIN ANALYZE to get insight into what approach Postgres is taking to execute queries and the actual performance of those approaches. You know that an Index Scan is preferable to a Seq Scan , but you’ll settle for a Heap Scan as a Join Cond. Query plans aren’t the easiest thing to read, however. They’re packed with information and it’s closer to being machine parsable than human readable. Visualize the problem Postgres Explain Viewer (PE...

Full article: https://robots.thoughtbot.com/advanced-postgres-performan...

Tweets

10 Tips in #LinkBuilding and Content Marketing ~ @lorenbaker

10 Tips in #LinkBuilding and Content Marketing ...

searchenginejournal.com 31 Jul '16, 8am

SEO Targets: Find the semantic modifiers of keyword buckets that drive context. For example, Starbucks might want to creat...

#APM Practices Every Enterprise Needs to Know. Are you using them?

#APM Practices Every Enterprise Needs to Know. ...

newrelic.com 29 Jul '16, 3pm

The great thing about using New Relic to monitor your applications is that it doesn’t just give you visibility into a cert...

Advanced SQL in Rails - Part 1

rubyflow.com 04 Aug '16, 9pm

× The Ruby and Rails community linklog Made a library? Written a blog post? Found a useful tutorial? Share it with the Rub...

.@adidas' Craig Vanderoef speak about the thoug...

runblogrun.com 29 Jul '16, 4am

The best interviews should be similar to conversations between confidantes. If one appreciates the focus of the interview,...

How to Improve Ruby on Rails Application Performance

How to Improve Ruby on Rails Application Perfor...

cryptextechnologies.com 07 Aug '16, 12am

Both significant factors in software performance are size of the database and program structure. Let's identify the reason...

#singapore #sales Caltex Superior Performance S...

sgrate.com 29 Jul '16, 2am

[Promotion ] Branded Bazaar at Takashimaya [Promotion ] John Little National Day Sale-Abration [Promotion ] Muji Raffles C...

Check out @Garden4Wildlife tips to create a birdbath your feathered neighbors can't resist:

Check out @Garden4Wildlife tips to create a bir...

nwf.org 29 Jul '16, 1pm

Birds love bird baths so they are a great way to put out the welcome mat for your favorite wildlife species. All you need ...

Localization key to reaching digitally advanced, well-educated Middle Easterners

Localization key to reaching digitally advanced...

luxurydaily.com 27 Jul '16, 8am

Recognizing the opportunities that exist in catering to Muslim consumers, a number of luxury brands have developed special...

Reading a Postgres EXPLAIN ANALYZE Query Plan

robots.thoughtbot.com 26 Jul '16, 12am

The most powerful tool at our disposal for understanding and optimizing SQL queries is EXPLAIN ANALYZE , which is a Postgr...

5 Tips to Effectively Leverage the Power of User Reviews

5 Tips to Effectively Leverage the Power of Use...

blogtrepreneur.com 28 Jul '16, 3pm

5 Tips to Effectively Leverage the Power of User Reviews There’s been a quiet shift of company/consumer power balance goin...