| 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 |
| Message-ID: | 20130925202332.GV4832@eldon.alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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 http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| minmax-5b-incr.patch | text/x-diff | 742 bytes |
| 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 |