What are different steps to optimize the postgres database and queries?

Question

I am optimizing Postgres with Ruby on Rails. For last few days I am finding that my site is loading slowly. Application is using different queries with join of 3-4 tables to fetch the data.

Could you help me what I need to do to improve the performance of the application at database level?

Your question is quite generic, so I wouldn't hope for really helpful answers. Personally I got a lot from reading the two books "Enterprise Rails" and "PostgreSQL 9.0 High Performance". — j.p.
– j.p., Commented Nov 1, 2013 at 13:57

Kuberchaun · Accepted Answer · 2013-11-01 14:52:26Z

1

Have a look here. You need to capture and look at all the activity and go from there. The link below provides a open source tool to do that.

http://dalibo.github.io/pgbadger/

answered Nov 1, 2013 at 14:52

Kuberchaun

30.5k8 gold badges54 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

What are different steps to optimize the postgres database and queries?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related