Re: What popular, large commercial websites run - Mailing list pgsql-general

From postgres@vrane.com
Subject Re: What popular, large commercial websites run
Date
Msg-id 20020501175247.A2477@amd.universe
Whole thread Raw
In response to Re: What popular, large commercial websites run  (Shaun Thomas <sthomas@townnews.com>)
Responses Re: What popular, large commercial websites run
Re: What popular, large commercial websites run
List pgsql-general
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

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: rowcount
Next
From: Neil Conway
Date:
Subject: Re: aggregate on zero rows slow?