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:53:14
Message-ID: 36e682920705311153r5c32ae60s822c9e7d034ee6c8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On 5/31/07, Andrew Sullivan <ajs(at)crankycanuck(dot)ca> wrote:
> They've delayed the pain too.  This is actually an illustration of
> what Tom Lane said recently -- that the strategy of paying the cost
> of maintenance outside the main transaction path is intrinsically
> superior, because you don't have to pay it while your user is sitting
> there waiting for you.

Or, you just use the features you pay for and use COMMIT NOWAIT.

-- 
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

Responses

pgsql-admin by date

Next:From: Jonah H. HarrisDate: 2007-05-31 18:54:54
Subject: Re: Deletes hurt
Previous:From: Tom LaneDate: 2007-05-31 17:54:04
Subject: Re: postgresql recovery (PANIC: btree_split_redo: lost left sibling)

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