> On Feb 27, 2014, at 4:57 AM, Ralf Jansen <[email protected]> wrote:
>
> Hi Karol,
>> Do you have only on test env. 400 transactions per second or it will be also
>> near number on real env?
>
> That’s was just for my test environment. But we have a few customers that
> reach counter limit in the real product in a year or so if they don't
> backup/restore.
I'm confused. I thought that read-only read-committed transactions did not
consume transaction ids. By nature they don't need the protection of the
transactional system. They don't make changes so there's no need to roll back.
Nor is there any need to prevent others from reading their uncommitted
changes. They don't offer consistent reads, so they don't need to prevent
garbage collection. Why do they need unique transaction identifiers?
best regards,
Ann