Re: What popular, large commercial websites run

On Wed, May 01, 2002 at 02:52:21PM -0500, Shaun Thomas wrote:
> Why are our databases bloating, even after hourly full vacuums?  Because
> we have a database with a 50-100% data turnover rate at about 100,000
> rows, and postgres just can't handle it.  I've watched our 100mb
> database grow to 500mb, then 2gigs.  Full dump and restore?  70mb
> again.  Oh, and the spiking load, and table locks that occur during
> full vacuums?  Just take the hit, web-surfers be damned.

Have you tried running frequent (more than hourly) non-full vacuums?

            regards, tom lane