SELECT in explicit transaction

From: "Blair Bethwaite" <blair(dot)bethwaite(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: SELECT in explicit transaction
Date: 2008-03-12 05:47:05
Message-ID: ab42a7c0803112247k3379bd31gac6418e6bdc36494@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

Browse pgsql-general by date

  From Date Subject
Next Message Blair Bethwaite 2008-03-12 05:53:07 SELECT overhead in explicit transaction
Previous Message Craig Ringer 2008-03-12 05:39:03 Re: Problem with starting PostgreSQL server 7.4.19