Row counts for large tables cause temporary hang

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Row counts for large tables cause temporary hang
Дата
Msg-id 408F5685.9080300@paradise.net.nz
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Jean-Michel POURE
Дата:
Сообщение: Re: Smoother PostgreSQL icons
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: Row counts for large tables cause temporary hang