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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Harris <lists(at)spuddy(dot)org>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Slow sequential scans on one DB but not another; fragmentation?
Date: 2007-03-28 15:36:27
Message-ID: 25274.1175096187@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephen Harris <lists(at)spuddy(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2007-03-28 15:42:21 Re: redhat debug info
Previous Message Tom Lane 2007-03-28 15:31:33 Re: unexpected data beyond EOF and character encoding