Re: Minmax indexes

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Erik Rijkers <er(at)xs4all(dot)nl>
Cc: Jaime Casanova <jaime(at)2ndquadrant(dot)com>, Thom Brown <thom(at)linux(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Minmax indexes
Date: 2013-09-25 20:23:32
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Erik Rijkers wrote:

> 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.

Thanks for the report. That's fixed with the attached.

> Below is the whole program that I used.

Hmm, this test program shows that you're trying to use the index to
optimize min() and max() queries, but that's not what these indexes do.
You will need to use operators > >= = <= < (or BETWEEN, which is the
same thing) to see your index in action.

Álvaro Herrera
PostgreSQL Development, 24x7 Support, Training & Services

Attachment Content-Type Size
minmax-5b-incr.patch text/x-diff 742 bytes

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2013-09-25 20:34:21 Re: Minmax indexes
Previous Message Alvaro Herrera 2013-09-25 20:16:52 Re: Minmax indexes