Re: Minmax indexes

On Wed, September 25, 2013 00:14, Alvaro Herrera wrote:
> [minmax-4-incr.patch]

After a  --data-checksums initdb (successful), the following error came up:



after the statement: create index t_minmax_idx on t using minmax (r);

WARNING:  page verification failed, calculated checksum 25951 but expected 0
ERROR:  invalid page in block 1 of relation base/21324/26267_vm

it happens reliably. every time I run the program.

Below is the whole program that I used.


Thanks,

Erik Rijkers






#!/bin/sh

t=t

if [[ 1 -eq 1 ]]; then
   echo "       drop table if exists $t ;       create table $t           as           select i, cast( random() * 10^9
asinteger ) as r           from generate_series(1, 1000000)  as f(i) ;   analyze $t;   table $t limit 5;   select
count(*)from $t;   explain analyze select min(r), max(r) from $t;                           select min(r), max(r) from
$t;
   create index ${t}_minmax_idx on $t using minmax (r);   analyze $t;
   explain analyze select min(r), max(r) from $t;                           select min(r), max(r) from $t;
   " | psql

fi