Postgres Pro
Downloads
Home   >   mailing lists

Re: transactions within stored procedures - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: transactions within stored procedures
Date
Msg-id AANLkTilQqn9JQMh-lp_162JCGVADWCyDWrWKqbQcVequ@mail.gmail.com
Whole thread Raw
In response to Re: transactions within stored procedures  (Robot Tom <robotwilcox@googlemail.com>)
List pgsql-general
Tree view 
On 21 July 2010 10:43, Robot Tom <robotwilcox@googlemail.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

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: locating cities within a radius of another
Next
From: Joe Conway
Date:
Subject: Re: locating cities within a radius of another