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 [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
