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)
Список
Дерево обсуждения
Large tables, copy-and-paste, default sql ow <oneway_111@yahoo.com>
Re: Large tables, copy-and-paste, default sql ow <oneway_111@yahoo.com>
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 по дате отправления