Re: Speed

I don't know how big your database is, but I have one with 23 tables of
varying sizes, the largest of which is 25,000 records. Each step in the
hierarchy, ie open connection, open database, open table, takes about 2
seconds. My server is a Dell P3 600mz  and my client  is a Dell P3
400mz. I use the same pgAdmin, but Postgres 7.2.1. Are you running any
other protocols besides tcp/ip?

Michiel_Lange@actuera.nl wrote:

>Fellow pgAdministrators,
>
>Shortly I went trying to use pgAdmin. I know pgAdmin uses ODBC, and I know
>that it is not the quickest form of connection you can get.
>I  can live with that... but I wondered if any of you is experiencing this
>kind of performance as well,  or have experienceD, and know a solution ;-)
>
>Connecting itself takes 5 seconds (I can live with that, no problem)
>Clicking on 'Databases' makes me wait at least 10 minutes (I have only one
>database of my own, aside the default databases) I cannot live with that...
>Listing the tables takes another 10 minutes at least etc etc... everything
>just takes ages...
>
>I really do not exaggerate, and think there ought to be a way to fix it...
>I have:
>pgAdmin 1.2.0 with databases on Postgres 7.2.2
>Today I upgraded pgODBC, but that did not really help... anyone?
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>
>