Re: big transaction slows down over time - but disk seems

From: Ben <bench(at)silentmedia(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: big transaction slows down over time - but disk seems
Date: 2006-11-01 16:51:46
Message-ID: Pine.LNX.4.64.0611010847431.5452@GRD.cube42.tai.silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 1 Nov 2006, Richard Huxton wrote:

> 1. Avoid updating the same timestamp more than once (if that's happening)

Each row is updated at most once, and not all rows are updated.

> 2. Update timestamps in one go at the end of the transaction (perhaps by
> loading updates into a temp table).

Hey, that's not a bad idea. I'll give that a shot. Thanks!

> 3. Split the transaction in smaller chunks of activity.

I'd be happy to do this too, except that I need a simple way to rollback
everything, and I don't see how I can get that with this.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2006-11-01 17:15:16 Re: big transaction slows down over time - but disk seems
Previous Message Richard Huxton 2006-11-01 16:34:12 Re: big transaction slows down over time - but disk seems