Thanks for the help. I'd seen the heap_page_items functions, but wanted to
avoid the superuser requirement and wondered if this was going to be a
performant method of finding the freeze column (we're scanning some
billions of rows).
Fwiw, we think we'll probably go with a tiny extension that expos
On Mon, Jul 20, 2020 at 9:07 PM Lawrence Jones wrote:
>
>
> So we hit the question: how can we identify if a tuple is frozen? I know the
> tuple has both committed and aborted hint bits set, but accessing those bits
> seems to require superuser functions and are unlikely to be that fast.
>
> Are
Hey all,
*tl;dr: we're looking for an easy way to ask if a tuple is frozen from
within a SQL query*
We're trying to build a validation process around our CCD, in an attempt to
validate that all data inside of Postgres has made it into our secondary
store.
Our plan is to build a small incremental
