ddgs <gsmaths@gmail.com> wrote:
> It is a discussion about the transaction ID wraparound in
> PostgreSQL.
Hopefully you've seen this:
http://www.postgresql.org/docs/current/static/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND
> However, what is the fundamental definition if transaction ID.
As the cited page states, it is 32 bits. It is considered a
"circular" number space.
> select * from table where ID=1:10000
> it is consider as one transaction or 10000 transactions.
In SQL it would be a syntax error; it doesn't really mean anything.
And it seems that you may be confused about the difference between
transaction IDs, object IDs, and user-defined ID columns on tables.
What is the "ID=1:10000" syntax supposed to mean?
-Kevin