On 3/4/17 12:39, Tomas Vondra wrote:
>> Can we have a test case for page_checksum(), or is that too difficult to
>> get running deterministicly?
>
> I'm not sure it can be made deterministic. Certainly not on heap pages,
> because then it'd be susceptible to xmin/xmax changes, but we have other
> bits that change even on index pages (say pd_lsn).
>
> So I'm afraid that's not going to fly.
Then just run it and throw away the result. See sql/page.sql for some
examples.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services