Re: Optimisation help - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Optimisation help
Date
Msg-id 20080304225445.GA14720@uio.no
Whole thread Raw
In response to Re: Optimisation help  (dforums <dforums@vieonet.com>)
List pgsql-performance
On Wed, Mar 05, 2008 at 12:15:25AM +0000, dforums wrote:
> In regards of update, I have around 10000 updates while a laps of 10 minutes
>
> Is there a settings to optimise updates ?

If you can, batch them into a single transaction.

If you can, upgrade to 8.3. HOT might help you here.

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: dforums
Date:
Subject: Re: Optimisation help
Next
From: Erik Jones
Date:
Subject: Re: Optimisation help