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



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

Reply via email to