Re: judging acceptable discrepancy in row count v. estimate

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: judging acceptable discrepancy in row count v. estimate
Дата
Msg-id 11839471-ABBC-4A14-BEEE-16695BE3D22F@gmail.com
обсуждение исходный текст
Ответ на Re: judging acceptable discrepancy in row count v. estimate  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

> On Oct 16, 2018, at 1:01 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Rob Sargent <robjsargent@gmail.com> writes:
>> Should reality be half again as large as the estimated row count?
>> coon=# select count(*) from sui.segment;
>>  count
>> ----------
>> 49,942,837  -- my commas
>> (1 row)
>
>> coon=# vacuum (analyse, verbose) sui.probandset;
>
> Uh, what does sui.probandset have to do with sui.segment ?
>
>             regards, tom lane

As the locals say, Oh My Heck. Nothing at all as far as row count is concern.  Deepest apologies.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: judging acceptable discrepancy in row count v. estimate
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: FATAL: terminating connection because protocol synchronizationwas lost