Re: Optimisation help

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: dforums <dforums(at)vieonet(dot)com>
Cc: Alan Hodgson <ahodgson(at)simkin(dot)ca>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimisation help
Date: 2008-03-04 22:54:45
Message-ID: 20080304225445.GA14720@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2008-03-04 22:59:47 Re: Optimisation help
Previous Message dforums 2008-03-04 22:21:22 Optimisation help