Re: DB become enormous with continuos insert and update - Mailing list pgsql-general

From Hfe80
Subject Re: DB become enormous with continuos insert and update
Date
Msg-id 1288253584275-3240118.post@n5.nabble.com
Whole thread Raw
In response to Re: DB become enormous with continuos insert and update  (Vick Khera <vivek@khera.org>)
Responses Re: DB become enormous with continuos insert and update  (Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>)
List pgsql-general
Thank to all
I couldn't respond yesterday but we had tried all you suggestion in the past
weeks.

But nothing change really
Now finally have resolve the problem!!!

It was a bug of version 8.1.
We solve all our problem simply update to 8.4 !!!

It's incredible, DB don't change dimension even after 1 million insert and
update.
CPUs average load  drastically is fallen down!

before 16 core server has an incredible average load from 2 to 16!
Now 16 core server now have nothing to do! :)  average load  is 0,1   :)

NB Thank you to friends of  http://www.nikos.it nikos  that has give us the
right suggestion.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/DB-become-enormous-with-continuos-insert-and-update-tp3237814p3240118.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: trevor1940
Date:
Subject: PostGIS return multiple points
Next
From: Gabriele Bartolini
Date:
Subject: Re: DB become enormous with continuos insert and update