Re: big transaction slows down over time - but disk seems - Mailing list pgsql-performance

From Ben
Subject Re: big transaction slows down over time - but disk seems
Date
Msg-id Pine.LNX.4.64.0611010847431.5452@GRD.cube42.tai.silentmedia.com
Whole thread Raw
In response to Re: big transaction slows down over time - but disk seems  (Richard Huxton <dev@archonet.com>)
Responses Re: big transaction slows down over time - but disk seems
List 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.




pgsql-performance by date:

Previous
From: Ben
Date:
Subject: Re: big transaction slows down over time - but disk seems almost unused
Next
From: Richard Huxton
Date:
Subject: Re: big transaction slows down over time - but disk seems