Re: What does Rows Counted mean

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: What does Rows Counted mean
Дата
Msg-id 5703F7ED.1080605@aklaver.com
обсуждение исходный текст
Ответ на Re: What does Rows Counted mean  (Melvin Davidson <melvin6925@gmail.com>)
Ответы Re: What does Rows Counted mean  (Melvin Davidson <melvin6925@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tobia Conforto
Дата:
Сообщение: Exclude constraint using custom operator
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: What does Rows Counted mean