Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] PATCH: pageinspect / add page_checksum andbt_page_items(bytea) - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] PATCH: pageinspect / add page_checksum andbt_page_items(bytea)
Date
Msg-id 85b5c036-436b-d534-c265-cb1d1bbca07a@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] PATCH: pageinspect / add page_checksum andbt_page_items(bytea)  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [HACKERS] [PATCH] Use $ parameters as replacement characters for pg_stat_statements
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Change in "policy" on dump ordering?