pgadmin not responding - Mailing list pgadmin-support

From Matt Doggett
Subject pgadmin not responding
Date
Msg-id 002101c40d1e$5b4cb430$2441c180@oce.orst.edu
Whole thread Raw
List pgadmin-support
I have a *very* large database (20 million+ records per table). When I
select a table, pgadmin wants to display various information about the
table properties. The message "Retrieving Table details." displays in
the status bar.  While it is doing this the program is effectively
non-responsive and when I look in the Task manager, I see the "Not
responding." message for any pgadmin windows.  In addition, if I change
my mind, I can't cancel the operation and I'm basically stuck until
pgadmin "revives".

Not sure if anything can be done about this, but I'd thought I'd let you
developer wizards know about this behavior on BIG tables.

-Matt

ps. On my system it takes about 2.5 minutes to get table information on
a table with nearly 21 million rows.

Matt Doggett
Spatial Climate Analysis Service
Oregon State University
316 Strand Ag Hall
Corvallis, OR 97331
(541)737-9153
mdoggett@coas.oregonstate.edu




pgadmin-support by date:

Previous
From: "Keith C. Perry"
Date:
Subject: Re: Data entry
Next
From: "Hiroshi Saito"
Date:
Subject: Re: pgadmin not responding