Re: What does Rows Counted mean

On Tue, Apr 5, 2016 at 1:37 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 04/05/2016 10:10 AM, Melvin Davidson wrote:
>
>>
>>
>>
>
>> FYI, in PgAdmin, there is an Option which determines if a _physical row
>> count_ should be performed if the _estimated_ row count is less than a
>> specified amount. It defaults to 2000.
>> To change it, Click on File, Options and under Browser click Properties.
>> There you can change the default.
>>
>
> So that means it does select count(*) from the_table every time you click
> on the table properties if the estimated count is less then the set amount?
>
>
> --
>> *Melvin Davidson*
>> I reserve the right to fantasize. Whether or not you
>> wish to share my fantasy is entirely up to you.
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

>So that means it does select count(*) from the_table every time you click
on the table properties if the estimated count is less then the set amount?
I believe so. That is why the default is low (2k). If you set it higher, it
will naturally take longer.
I did not write or contribute to PgAdmin, so there is no point in
complaining about it. It's just a user option.

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.