Re: [GENERAL] SELECT overhead in explicit transaction

2008-03-11 Thread Tom Lane
"Blair Bethwaite" <[EMAIL PROTECTED]> writes: > 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? Every PG command is executed in a transaction, whether expli

[GENERAL] SELECT overhead in explicit transaction

2008-03-11 Thread Blair Bethwaite
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,