Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Stephen Harris <lists@xxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux