Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal - Mailing list pgsql-performance

From Michael Stone
Subject Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal
Date
Msg-id 20070516162035.GI1785@mathom.us
Whole thread Raw
In response to Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-performance
On Wed, May 16, 2007 at 12:09:26PM -0400, Alvaro Herrera wrote:
>Maybe, but we should also mention that CLUSTER is a likely faster
>workaround.

Unless, of course, you don't particularly care about the order of the
items in your table; you might end up wasting vastly more time rewriting
tables due to unnecessary clustering than for full vacuums on a table
that doesn't need it.

Mike Stone

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal
Next
From: Chris Browne
Date:
Subject: Re: [doc patch] a slight VACUUM / VACUUM FULL doc improvement proposal