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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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