| From: | Hfe80 <federico(dot)mo(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: DB become enormous with continuos insert and update |
| Date: | 2010-10-28 08:13:04 |
| Message-ID: | 1288253584275-3240118.post@n5.nabble.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dan.m.harris | 2010-10-28 11:42:16 | Can't take base back up with Postgres 9.0 on Solaris 10 |
| Previous Message | trevor1940 | 2010-10-28 08:00:38 | PostGIS return multiple points |