| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Rajeev rastogi <rajeev(dot)rastogi(at)huawei(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Subject: | Re: Autonomous Transaction is back |
| Date: | 2015-07-24 19:39:11 |
| Message-ID: | CAHyXU0zK2XRimLW15ESU7fozpctvOFB-jB7++B1jhVWGxgCWkQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Jul 23, 2015 at 1:49 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> Batch Jobs: large data-manipulation tasks which need to be broken up
> into segments, with each segment committing separately. Example:
> updating 1 million records in batches of 1000.
Autonomous transactions are not a good fit for this case; stored
procedures are a better way to go for any scenario where you don't
want be be in a snapshot (for example, suppose you want to change
isolation level on the fly).
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2015-07-24 19:58:12 | Re: RLS fails to work with UPDATE ... WHERE CURRENT OF |
| Previous Message | Robert Haas | 2015-07-24 19:02:31 | Re: RFC: replace pg_stat_activity.waiting with something more descriptive |