I just began working with PostgreSQL and have found both pgAdmin and Navicat to be really slow. Its slow to open a database, list the tables and list the first 100 rows. The db I'm looking at is very small and I'm running on a macbook air so I don't see hardware being the problem.
Is this a common issue? Is there a way to speed things up? I've used mysql or sqlite3 and their tools are far quicker.
EDIT: I should also point out that I recently upgraded from OS X Snow Leopard to Lion. Would the default postgreSQL install on Lion cause interference?