Re: What does Rows Counted mean - Mailing list pgsql-general

From Adrian Klaver
Subject Re: What does Rows Counted mean
Date
Msg-id 5703F7ED.1080605@aklaver.com
Whole thread Raw
In response to Re: What does Rows Counted mean  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: What does Rows Counted mean
List pgsql-general
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.klaver@aklaver.com


pgsql-general by date:

Previous
From: Tobia Conforto
Date:
Subject: Exclude constraint using custom operator
Next
From: Melvin Davidson
Date:
Subject: Re: What does Rows Counted mean