Re: Savepoints in transactions for speed?

From: Willem Leenen <willem_leenen(at)hotmail(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Savepoints in transactions for speed?
Date: 2012-11-28 06:03:20
Message-ID: DUB104-W12BEF6EBABB38275E561508F5D0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Savepoint are not created for performance. If you have one very long running transactions that fails in the end, it will all be rolled back. So be pretty sure about your dataquality or use safepoints.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message suhas.basavaraj12 2012-11-28 06:45:11 pgsql_tmp( Temporary tablespace)
Previous Message Franklin, Dan 2012-11-28 03:08:44 Re: Savepoints in transactions for speed?