Re: What does Rows Counted mean

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: What does Rows Counted mean
Date: 2016-04-05 17:37:49
Message-ID: 5703F7ED.1080605@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2016-04-05 17:43:46 Re: What does Rows Counted mean
Previous Message Tobia Conforto 2016-04-05 17:30:25 Exclude constraint using custom operator