SELECT overhead in explicit transaction

From: "Blair Bethwaite" <blair(dot)bethwaite(at)infotech(dot)monash(dot)edu(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: SELECT overhead in explicit transaction
Date: 2008-03-12 05:53:07
Message-ID: ab42a7c0803112253m239678a4o511ab41e85e2af72@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm wondering whether there would be any extra overhead (CPU, memory,
io, etc), above and beyond the implicit ACCESS SHARE, incurred by
putting a simple SELECT into a transaction block?

Cheers,
-Blair

--
In science one tries to tell people, in such a way
as to be understood by everyone, something that
no one ever knew before. But in poetry, it's the
exact opposite.
- Paul Dirac

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-03-12 06:02:34 Re: Problem with starting PostgreSQL server 7.4.19
Previous Message Blair Bethwaite 2008-03-12 05:47:05 SELECT in explicit transaction