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

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: ow <oneway_111(at)yahoo(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Large tables, copy-and-paste, default sql
Date: 2003-11-10 08:56:31
Message-ID: 3FAF52BF.7070003@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2003-11-10 09:04:40 Re: RE
Previous Message Дмитрий Попов 2003-11-10 08:55:14 Bug