Re: Slow sequential scans on one DB but not another; fragmentation?

Stephen Harris <lists@spuddy.org> writes:
> INFO:  "sweep_users": found 835831 removable, 972662 nonremovable row versions in 2890304 pages
> DETAIL:  0 dead row versions cannot be removed yet.
> There were 112212932 unused item pointers.

Oy, that's one bloated table ... only one live row in every three or so pages.

Probably a CLUSTER is the most effective way of cleaning it up.  Once
you get it down to size, revisit your vacuuming policy, because it
definitely isn't getting vacuumed often enough.

            regards, tom lane