Thread: pgadmin not responding
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
Dear Matt Doggett. If 1.0.2 was being used. Please Try to set 'Count row if estimated less then' of Options on 0. Or, try to use the latest 1.1.0developer. A condition is fine though I am 10 million cases. regards, Hiroshi Saito ----- Original Message ----- From: "Matt Doggett" <mdoggett@coas.oregonstate.edu> > 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. >
> -----Original Message----- > From: Matt Doggett [mailto:mdoggett@coas.oregonstate.edu] > Sent: 18 March 2004 19:23 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] pgadmin not responding > > 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. Hi Matt, The only thing pgAdmin does that should be affected by large tables is count the number of rows in them. As long as you have analysed the database and the statistics roughly reflect the true size of the table then you can set a threshold level on the options dialogue - if the statistics count is higher than the threshold, the count is skipped. Regards, Dave.