Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Does PostgreSQL have good performance or administration tools?
I have been using postgres for quite some time now, but I still do not know a huge amount about ways to optimise and maintain a database, and keep it running well.
I have had a look through the manual, but since it is quite a mature product, I am assuming there are a couple of 'must-have' utilities for it?
Perhaps not what you're looking for, but plain old psql is excellent. You can tell that the devs really meant for it to be a comfortable place to spend a lot of time.
For general schema navigation DBVisualizer is quite nice.
For performance information there are hardly any complete tools like MySQL Enterprise Monitor; I'd suggest to use pgFouine (already suggested) and any tool that can graph performance data (like Munin for example), collect the relevant information from PostgreSQL (pg_stat_ views/system tables) and the system itself (memory, cpu, disk utiliziation, etc.) and use this as a basis for deducing trends.
This book has a few chapters on PostgreSQL performance; the PostgreSQL Wiki has a list of presentations on this topic.
pgFouine is a great log analyzer that has helped many times in the past. It is really easy to set up too. At one point the project ran on Rails, but I think it's using PHP now.
+1 because it is a great tool. It looks like the project hasn't been touched in a long time. It also has a lot of issues processing a lot of data (it is a PHP script after all).