Skip site navigation (1) Skip section navigation (2)

pgadmin not responding

From: "Matt Doggett" <mdoggett(at)coas(dot)oregonstate(dot)edu>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: pgadmin not responding
Date: 2004-03-18 19:22:30
Message-ID: 002101c40d1e$5b4cb430$ (view raw, whole thread or download thread mbox)
Lists: 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.


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


pgadmin-support by date

Next:From: Hiroshi SaitoDate: 2004-03-18 20:43:12
Subject: Re: pgadmin not responding
Previous:From: Keith C. PerryDate: 2004-03-18 18:43:58
Subject: Re: Data entry

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group