PostgreSQL performance Analysis

1. http://engineering-blog.alphasights.com/how-to-stop-worrying-and-love-the-index/
2. http://stackoverflow.com/questions/6592626/what-is-a-bitmap-heap-scan-in-a-query-plan
3. https://devcenter.heroku.com/articles/postgresql-indexes
4. http://michael.otacoo.com/postgresql-2/postgres-9-4-feature-highlight-lossyexact-pages-for-bitmap-heap-scan/
5. http://pglearner.blogspot.com/2015/01/learning-bitmap-index-scan-recheck-cond.html
6. http://www.postgresql.org/message-id/12553.1135634231@sss.pgh.pa.us
7. http://dba.stackexchange.com/questions/119386/understanding-bitmap-heap-scan-and-bitmap-index-scan?newreg=52a072b9a8fa49fc989ed058adda8505
8. http://dba.stackexchange.com/questions/106264/recheck-cond-line-in-query-plans-with-a-bitmap-index-scan
9. http://stackoverflow.com/questions/410586/what-is-the-difference-between-seq-scan-and-bitmap-heap-scan-in-postgres
10. http://stackoverflow.com/questions/10145037/understanding-postgres-explain-w-bitmap-heap-index-scans
11. http://ask.use-the-index-luke.com/questions/148/why-is-this-postgres-query-doing-a-bitmap-heap-scan-after-the-index-scan
12. http://www.postgresql.org/docs/8.1/static/performance-tips.html
13. http://www.tech-recipes.com/rx/47637/inner-and-left-outer-join-with-where-clause-vs-on-clause/
14. http://stackoverflow.com/questions/15706112/why-and-when-a-left-join-with-condition-in-where-clause-is-not-equivalent-to-the
15. http://stackoverflow.com/questions/4752455/left-join-with-where-clause
16. https://www.digitalocean.com/community/tutorials/how-to-create-remove-manage-tables-in-postgresql-on-a-cloud-server
17. https://momjian.us/main/writings/pgsql/aw_pgsql_book/node195.html
18. http://www.revsys.com/writings/postgresql-performance.html
19. http://genius.com/Genius-engineering-team-one-weird-trick-to-make-postgresql-15000x-faster-annotated
20. https://en.wikipedia.org/wiki/Bitmap_index
21. http://stackoverflow.com/questions/6592626/what-is-a-bitmap-heap-scan-in-a-query-plan
22. http://engineering-blog.alphasights.com/how-to-stop-worrying-and-love-the-index/
23. http://www.postgresql.org/message-id/6638.1456795348@sss.pgh.pa.us
24. https://www.datadoghq.com/blog/100x-faster-postgres-performance-by-changing-1-line/
25. http://stackoverflow.com/questions/6777456/list-all-index-names-column-names-and-its-table-name-of-a-postgresql-database
26. https://devcenter.heroku.com/articles/postgresql-indexes
27. http://www.tutorialspoint.com/postgresql/postgresql_indexes.htm
28. https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
29. https://developers.google.com/identity/protocols/OAuth2InstalledApp#handlingtheresponse