Re: transactions within stored procedures

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: Robot Tom <robotwilcox(at)googlemail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: transactions within stored procedures
Date: 2010-07-21 15:14:25
Message-ID: AANLkTilQqn9JQMh-lp_162JCGVADWCyDWrWKqbQcVequ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 21 July 2010 10:43, Robot Tom <robotwilcox(at)googlemail(dot)com> wrote:
> Hi,
>
> Has there been any progress on nested transactions in the last 10 years?
>

PostgreSQL has had subtransactions since version 8.0, if that's what
you mean. If you're experiencing OOM a lot, a high work_mem setting is
often the culprit. This can be set dynamically though.

--
Regards,
Peter Geoghegan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2010-07-21 15:43:34 Re: locating cities within a radius of another
Previous Message Andy Colson 2010-07-21 15:10:54 Re: locating cities within a radius of another