Re: What popular, large commercial websites run
От | postgres@vrane.com |
---|---|
Тема | Re: What popular, large commercial websites run |
Дата | |
Msg-id | 20020501175247.A2477@amd.universe обсуждение исходный текст |
Ответ на | Re: What popular, large commercial websites run (Shaun Thomas <sthomas@townnews.com>) |
Ответы |
Re: What popular, large commercial websites run
Re: What popular, large commercial websites run |
Список | 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 по дате отправления: