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

Re: Deletes hurt

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Andrew Sullivan" <ajs(at)crankycanuck(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Deletes hurt
Date: 2007-05-31 18:54:54
Message-ID: 36e682920705311154u47876e1cub99a1d6065ddb4d0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On 5/31/07, Jonah H. Harris <jonah(dot)harris(at)gmail(dot)com> wrote:
> Or, you just use the features you pay for and use COMMIT NOWAIT.

Doh!  Got mixed up on the conversation, that wouldn't help.  But you
could use Oracle's in-memory UNDO, which would not be as costly as a
normal update.

-- 
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 3rd Floor            | jharris(at)enterprisedb(dot)com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/

In response to

pgsql-admin by date

Next:From: Chris HooverDate: 2007-05-31 19:10:13
Subject: Re: Deletes hurt
Previous:From: Jonah H. HarrisDate: 2007-05-31 18:53:14
Subject: Re: Deletes hurt

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