Re: [GENERAL] SELECT overhead in explicit transaction

2008-03-12 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 explicit or

[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