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