Re: Deletes hurt - Mailing list pgsql-admin

From Jonah H. Harris
Subject Re: Deletes hurt
Date
Msg-id 36e682920705311153r5c32ae60s822c9e7d034ee6c8@mail.gmail.com
Whole thread Raw
In response to Re: Deletes hurt  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: Deletes hurt  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-admin
On 5/31/07, Andrew Sullivan <ajs@crankycanuck.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@enterprisedb.com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql recovery (PANIC: btree_split_redo: lost left sibling)
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Deletes hurt