On Wed, May 01, 2002 at 02:52:21PM -0500, Shaun Thomas wrote:
> On Mon, 29 Apr 2002, pgsql-gen Newsgroup wrote:
>
> > The way I see it, some managers will buy Oracle. They will have low
> > profit margines. Some programers will use PostgreSQL. They will have
> > high margins.
>
>
> 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.
>
I'm very curious to know why you have problem with growing
database. Does the performance suffer significantly
if you don't do the FULL vacuum? Surely if you can
afford the oracle you can afford relatively much
cheaper storage. You must have other reasons
than just not liking large database
Thanks