From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "maruthi maruthi" <maruthi49(at)hotmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Transaction id inrement |
Date: | 2001-08-20 15:22:45 |
Message-ID: | 8801.998320965@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"maruthi maruthi" <maruthi49(at)hotmail(dot)com> writes:
> Transaction id is incremented even in sql queries like
> "select" which does not change the state of database, is it not
> unnecesary?.
No, it's not unnecessary. Every DB operation has to have a transaction
ID; what's more, we have to assign one long before we have any idea
whether the transaction will prove to be read-only.
It's at least theoretically possible that we could recycle the
transaction ID of a completed transaction that's proven to be read-only,
but the bookkeeping involved would be far more trouble than it's worth.
Not least because it would break MVCC assumptions about transactions
starting in sequence number order.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-08-20 15:27:58 | Re: Guide to PostgreSQL source tree |
Previous Message | Matthew T. O'Connor | 2001-08-20 15:14:19 | Re: CREATEDB Where ?? |