Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group