Re: Why there is 30000 rows is sample

On 2020-04-04 10:07:51 +0300, Andrus wrote: > vacuumdb: vacuuming database "mydb" > INFO: analyzing "public.mytable" > INFO: "mytable": scanned 2709 of 2709 pages, containing 10834 live rows and > 0 dead rows; 10834 rows in sample, 10834 estimated total rows > > For tables with more than 3 r

Re: Why there is 30000 rows is sample

Hi, On Sat, Apr 04, 2020 at 10:07:51AM +0300, Andrus wrote: > Hi! > > vacuumdb output: > > vacuumdb: vacuuming database "mydb" > INFO: analyzing "public.mytable" > INFO: "mytable": scanned 2709 of 2709 pages, containing 10834 live rows and > 0 dead rows; 10834 rows in sample, 10834 estimated t

Why there is 30000 rows is sample

Hi! vacuumdb output: vacuumdb: vacuuming database "mydb" INFO: analyzing "public.mytable" INFO: "mytable": scanned 2709 of 2709 pages, containing 10834 live rows and 0 dead rows; 10834 rows in sample, 10834 estimated total rows For tables with more than 3 rows, it shows that there are 3