Re: [pgAdmin4][Patch]: To handle long numbers for Rows (estimated) field in Table's properties

From: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: [pgAdmin4][Patch]: To handle long numbers for Rows (estimated) field in Table's properties
Date: 2017-11-01 13:20:15
Message-ID: CAKKotZRiaEb3g350UeHTG4zXS0uioP2gkECsJR5PNx=LKngEPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Thanks Dave, I'll check the implementation in pgAdmin3 & send new patch
with suggested changes.

On Wed, Nov 1, 2017 at 6:41 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Hi
>
> On Wed, Nov 1, 2017 at 11:58 AM, Murtuza Zabuawala <
> murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>
>> Hi,
>>
>> PFA patch to fix the issue where "Rows (estimated)" field was not
>> displaying long number properly.
>> RM#2386
>>
>> I have also added the code to count actual rows in a table [ "Rows
>> (counted)" filed ] which was missing.
>>
>
> Oops. Well the idea is good, but unfortunately we want to be careful about
> when we count the rows, as we could have just clicked on a 10B row table
> which would take a while. To avoid that, pgAdmin III would only count the
> rows in the table if the estimated number of rows was below a specific
> value (see File -> Preferences -> Browser -> Properties -> "Count rows if
> estimated less than").
>
> I think we need to do the same here - add a preferences option, and only
> count if estimated is greater than the specified value (the default for
> which was 2000 in pgAdmin III I believe).
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Murtuza Zabuawala 2017-11-01 14:08:49 Re: [pgAdmin4][Patch]: To handle long numbers for Rows (estimated) field in Table's properties
Previous Message Dave Page 2017-11-01 13:11:45 Re: [pgAdmin4][Patch]: To handle long numbers for Rows (estimated) field in Table's properties