Skip site navigation (1) Skip section navigation (2)

Re: ??: Postgresql update op is very very slow

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: ??: Postgresql update op is very very slow
Date: 2008-06-26 13:55:01
Message-ID: 20080626135501.GF6918@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Jun 26, 2008 at 09:16:25PM +0800, Craig Ringer wrote:

> I think Pg already does in place updates, or close, if the tuples being 
> replaced aren't referenced by any in-flight transaction. I noticed a while 
> ago that if I'm doing bulk load/update work, if there aren't any other 
> transactions no MVCC bloat seems to occur and updates are faster.

Are you on 8.3?  That may be HOT working for you.  MVCC doesn't get
turned off if there are no other transactions (it can't: what if
another transaction starts part way through yours?).

A

-- 
Andrew Sullivan
ajs(at)commandprompt(dot)com
+1 503 667 4564 x104
http://www.commandprompt.com/

In response to

pgsql-performance by date

Next:From: Mark MielkeDate: 2008-06-26 14:53:21
Subject: Re: ??: Postgresql update op is very very slow
Previous:From: Andrew SullivanDate: 2008-06-26 13:53:41
Subject: Re: ??: Postgresql update op is very very slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group