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 as integer ) 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