Re: Performance question: Commit or rollback?

From: Chris Angelico <rosuav(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance question: Commit or rollback?
Date: 2011-12-18 03:05:59
Message-ID: CAPTjJmoOEsXwT9P-jcY1mSLAoO29V1589ewPx4q14yrOBSXBjQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Dec 18, 2011 at 2:02 PM, Chris Travers <chris(dot)travers(at)gmail(dot)com> wrote:
> I do not believe there are performance penalties for either.  All
> commit or rollback does is determine visibility of changes made.

Thanks. (And thanks for the incredibly quick response!)

My framework has a "read-only mode" (determined by user-level access),
in which it begins a read-only transaction. At the end of it, I
currently have it rolling the transaction back (to make absolutely
sure that no changes will be made), but was concerned that this might
place unnecessary load on the system. I'll stick with rolling back,
since it's not going to hurt!

Chris Angelico

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-12-18 04:25:47 Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..."
Previous Message Chris Travers 2011-12-18 03:02:00 Re: Performance question: Commit or rollback?