Re: [GENERAL] transactions within stored procedures

2010-07-21 Thread Peter Geoghegan
On 21 July 2010 10:43, Robot Tom 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 s

Re: [GENERAL] transactions within stored procedures

2010-07-21 Thread Robot Tom
Hi, Has there been any progress on nested transactions in the last 10 years? I am in a situation where I have a script that executes a number of functions that build and populate a database including a rather large lookup table (80GB) along with a number of large indexes (10GB). I am trying