Postgres Pro
Downloads
Home   >   mailing lists

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

From Gabriele Bartolini
Subject Re: DB become enormous with continuos insert and update
Date
Msg-id a0ccf67f138911643cb4705003571601@mail.xcon.it
Whole thread Raw
In response to Re: DB become enormous with continuos insert and update  (Hfe80 <federico.mo@gmail.com>)
List pgsql-general
Tree view 
Hello,

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

Well ... it was not a bug, actually a feature that was not yet
implemented.

My first question about which version of PostgreSQL you were using in this
thread was exactly for that purpose, but ... you never replied to that.

Next time, please post the version you are using and possibly the
operating system.

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

Glad you fixed it.

Ciao,
Gabriele

--
 Gabriele Bartolini - 2ndQuadrant Italia
 PostgreSQL Training, Services and Support
 Gabriele.Bartolini@2ndQuadrant.it - www.2ndQuadrant.it
 http://www.2ndquadrant.com/books/

pgsql-general by date:

Previous
From: Hfe80
Date:
Subject: Re: DB become enormous with continuos insert and update
Next
From: Adrian Klaver
Date:
Subject: Re: Can't take base back up with Postgres 9.0 on Solaris 10