Re: Large tables, copy-and-paste, default sql

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: Large tables, copy-and-paste, default sql
Дата
Msg-id 3FAF52BF.7070003@pse-consulting.de
обсуждение исходный текст
Ответ на Re: Large tables, copy-and-paste, default sql  ("Dave Page" <dpage@vale-housing.co.uk>)
Список pgadmin-support
Dave Page wrote:

>>
>>1. Tree view that shows the list of tables: When I click on a 
>>table that contains relatively large number of rows (20M+), 
>>it takes pgAdmin a very, very long time to show the 
>>respective CREATE clause for the table. It appears that 
>>pgAdmin is forcing pgSql to count rows in the table, though I 
>>may be wrong. Is there a way to avoid the delay?
>>    
>>
>
>pgAdmin checks the estimated row count before actually counting rows.
>You can set the threshold that will prevent counting under
>Tools->Options.
>  
>
Please note that there is  a float interpretation problem in 1.0.0 
(7.6e6 -> 7 instead of 7000000), which leads to wrong table size 
estimated values (and thus wrong thresholds for automatic row counting).

Regards,
Andreas




В списке pgadmin-support по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: Large tables, copy-and-paste, default sql
Следующее
От: Andreas Pflug
Дата:
Сообщение: Re: RE