ddgs <gsmaths@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
