Postgres Pro
Downloads
Home   >   mailing lists

Re: Savepoints in transactions for speed? - Mailing list pgsql-performance

From Willem Leenen
Subject Re: Savepoints in transactions for speed?
Date
Msg-id DUB104-W12BEF6EBABB38275E561508F5D0@phx.gbl
Whole thread Raw
In response to Re: Savepoints in transactions for speed?  ("Franklin, Dan" <dan.franklin@pearson.com>)
List pgsql-performance
Tree view

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.

pgsql-performance by date:

Previous
From: "Franklin, Dan"
Date:
Subject: Re: Savepoints in transactions for speed?
Next
From: "suhas.basavaraj12"
Date:
Subject: pgsql_tmp( Temporary tablespace)