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

On Wed, Mar 28, 2007 at 11:36:27AM -0400, Tom Lane wrote:
> Stephen Harris <lists(at)spuddy(dot)org> writes:
> > INFO: "sweep_users": found 835831 removable, 972662 nonremovable row versions in 2890304 pages

> 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

OK, we were doing a code release today and so had a change window open.
We ran a cluster command on this table. It took 15 minutes to complete,
and the number of pages went down to 27,000 - ie by a factor of 100.
"select count(*)" took 4 seconds instead of 220, giving us a 55 times
speed increase.

We'll keep our eye on this but since it was relatively quick we might
schedule a weekly cluster "just in case".

Thanks!

--

rgds
Stephen