Row counts for large tables cause temporary hang - Mailing list pgadmin-hackers

From Mark Kirkwood
Subject Row counts for large tables cause temporary hang
Date
Msg-id 408F5685.9080300@paradise.net.nz
Whole thread Raw
List pgadmin-hackers
Dear list,

Just recently downloaded Pgadmin III 1.0.2 for win32, and am using it
against (native) win32 Pg 7.5dev (to get a nicer client interface) - I
am very impressed with Pgadmin, it rocks!

The only gripe I have is the seemingly automatic count on tables as they
are clicked on - this hangs Pgadmin for minutes on one of the big tables
(10 million rows).

By way of a suggestion, I wondered about this logic :

- analyze the table instead of counting it
- if estimated count is < (configurable limit), then count for real,
otherwise use the estimate.


Apologies if you guys have done something like this, and my using 7.5dev
is confusing things :-)

regards

Mark

pgadmin-hackers by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: Smoother PostgreSQL icons
Next
From: "Dave Page"
Date:
Subject: Re: Row counts for large tables cause temporary hang