Finding new or modified rows since snapshot
| От | Meel Velliste |
|---|---|
| Тема | Finding new or modified rows since snapshot |
| Дата | |
| Msg-id | CAKDa2+=yOZ1YZZ9L=eFBbQiaa9N7ksDLUp8TuDMxiYAjnPeLFg@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Finding new or modified rows since snapshot
|
| Список | pgsql-general |
My goal is to select rows that are new or have been modified since a given snapshot. I am doing it like this:
SELECT * FROM my_table WHERE NOT txid_visible_in_snapshot(xmin::TEXT::BIGINT, '123456:123456:'::TXID_SNAPSHOT);
On one hand, it seems to me that the txid_visible_in_snapshot function was taylor-made for what I am trying to accomplish. On the other hand, it seems wrong because the first argument of txid_visible_in_snapshot is BIGINT, and I am trying to coerce a xmin which is of type XID into this argument.
So I have three questions:
1) Is this a good way to accomplish my goal (keep in mind I have read-only access to the db)?
2) Will it fail when xmin wraps around at 2^32 or is txid_visible_in_snapshot smart about it?
3) Is it going to be performant (xmin is not indexed, is it)?
Thanks,
Meel
В списке pgsql-general по дате отправления: