Re: judging acceptable discrepancy in row count v. estimate

2018-10-16 Thread Rob Sargent
> On Oct 16, 2018, at 1:01 PM, Tom Lane wrote: > > Rob Sargent 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.

Re: judging acceptable discrepancy in row count v. estimate

2018-10-16 Thread Rob Sargent
> On Oct 16, 2018, at 1:01 PM, Tom Lane wrote: > > Rob Sargent 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.

Re: judging acceptable discrepancy in row count v. estimate

2018-10-16 Thread Tom Lane
Rob Sargent 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.s

judging acceptable discrepancy in row count v. estimate

2018-10-16 Thread Rob Sargent
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; INFO: vacuuming "sui.probandset" INFO: scanned index "probandset_pkey" to remove 31