| From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
|---|---|
| To: | pgadmin-hackers(at)postgresql(dot)org |
| Subject: | Row counts for large tables cause temporary hang |
| Date: | 2004-04-28 07:00:21 |
| Message-ID: | 408F5685.9080300@paradise.net.nz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2004-04-28 07:13:16 | Re: Row counts for large tables cause temporary hang |
| Previous Message | Peter Eisentraut | 2004-04-26 15:02:59 | Re: Smoother PostgreSQL icons |