Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Apr 5 '12 at 9:13

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer

pgAdmin should hardly hesitate to display the first 100 rows (unless you include huge rows). I have been using it daily for the last couple of years.

Unless something is wrong in your installation, the delay is probably due to some other factors like network overhead or excessive load on your database server or local machine.

Old versions have various performance issues. Try upgrading to the current version 1.14.2 in this case.

Just tested with pgAdmin 1.14.2 in Win XP, Server pg 9.1 on Debian Squeeze: "View data" ->"Top 100 rows", table with 25 rows including some longer text columns (3x ~ 150 char), over the net, SSL encrypted. Hardly took a second until the display was complete.

If that happens just with this particular table, it might be an issue with vacuuming. Run a test with psql if that is just as slow. Some old versions of pgAdmin are very slow if bytea columns are included.

share|improve this answer
    
Perhaps I'm being too impatient? It takes about 6-8 seconds to display the first <100 rows (with about 10 columns). Admittedly this isn't a huge amount of time but its a lot longer than say mysql/sqlite3. –  Ger Apr 4 '12 at 10:07
    
@Gearóid: No, you are not impatient, that's very slow. I added an example to my answer. –  Erwin Brandstetter Apr 4 '12 at 14:28
    
Running psql from the command line and doing a simple select on the table is pretty much instantaneous which suggests its a connection to the Postgres server thats the issue? Please note that the database is local so this shouldnt be an issue. I've noticed that listing records in my application takes a long time too. Any ideas? Thanks for your help with this! –  Ger Apr 5 '12 at 9:51
    
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? –  Ger Apr 5 '12 at 9:54
    
Sorry, I don't know about OS X. –  Erwin Brandstetter Apr 5 '12 at 15:35
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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