Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

closed as not constructive by mgorven, Stefan Lasiewski, Bryan, Dave M, Michael Hampton Feb 13 '13 at 23:57

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

7 Answers 7

up vote 13 down vote accepted

I think that PgAdmin is pretty popular. There's also PhpPgAdmin, which is rougly analagous to the very popular phpMyAdmin.

share|improve this answer

For real simple tasks we use phpPgAdmin.

phpPgAdmin is a web-based administration tool for PostgreSQL. It is perfect for PostgreSQL DBAs, newbies and hosting services.

share|improve this answer

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.

share|improve this answer

pgFouine

http://pgfouine.projects.postgresql.org/

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.

share|improve this answer
    
+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). –  Trey May 29 '09 at 17:00

this guy has developed quite a few useful tools. take a look at his blog.

share|improve this answer

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.

And for specific questions there's always the pgsql-performance mailinglist and it's comprehensive archive.

share|improve this answer

TeamPostgreSQL is by far the best I've ever used.

  • Works on any platform (Windows, OS X, or Linux)
  • No stability issues that I've encountered (pgAdmin plagued me with them)
  • Columns can be sorted by clicking on them (unlike pgAdmin)
  • DB hosts not hard coded into a config file (unlike phpPgAdmin)
  • Doesn't feel antiquated

Major drawback: it doesn't support SSL connections.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.