Re: Database size Vs performance degradation

On Wed, 2008-07-30 at 13:51 -0400, Tom Lane wrote:
>
>
> Huh?  Vacuum doesn't block writes.
>
>                         regards, tom lane
>

Of course, you are correct.  I was thinking of Vacuum full, which is
recommended for use when you're deleting the majority of rows in a
table.

http://www.postgresql.org/docs/8.1/interactive/sql-vacuum.html

-Mark