Re: Minmax indexes

On 17 September 2013 07:20, Jaime Casanova <jaime(at)2ndquadrant(dot)com> wrote:

> On Mon, Sep 16, 2013 at 3:47 AM, Thom Brown <thom(at)linux(dot)com> wrote:
> > On 15 September 2013 01:14, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
> wrote:
> >>
> >> Hi,
> >>
> >> Here's a reviewable version of what I've dubbed Minmax indexes.
> >>
> > Thanks for the patch, but I seem to have immediately hit a snag:
> >
> > pgbench=# CREATE INDEX minmaxtest ON pgbench_accounts USING minmax (aid);
> > PANIC: invalid xlog record length 0
> >
>
> fwiw, this seems to be triggered by ANALYZE.
> At least i can trigger it by executing ANALYZE on the table (attached
> is a stacktrace of a backend exhibiting the failure)
>
> Another thing is this messages i got when compiling:
> """
> mmxlog.c: In function ‘minmax_xlog_revmap_set’:
> mmxlog.c:161:14: warning: unused variable ‘blkno’ [-Wunused-variable]
> bufpage.c: In function ‘PageIndexDeleteNoCompact’:
> bufpage.c:1066:18: warning: ‘lastused’ may be used uninitialized in
> this function [-Wmaybe-uninitialized]
> """
>

I'm able to run ANALYSE manually without it dying:

pgbench=# analyse pgbench_accounts;
ANALYZE
pgbench=# analyse pgbench_accounts;
ANALYZE
pgbench=# create index minmaxtest on pgbench_accounts using minmax (aid);
PANIC: invalid xlog record length 0

--
Thom