Re: judging acceptable discrepancy in row count v. estimate - Mailing list pgsql-general

From Rob Sargent
Subject Re: judging acceptable discrepancy in row count v. estimate
Date
Msg-id 11839471-ABBC-4A14-BEEE-16695BE3D22F@gmail.com
Whole thread Raw
In response to Re: judging acceptable discrepancy in row count v. estimate  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: judging acceptable discrepancy in row count v. estimate
Next
From: Adrian Klaver
Date:
Subject: Re: FATAL: terminating connection because protocol synchronizationwas lost