From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Minmax indexes |
Date: | 2013-09-17 08:30:12 |
Message-ID: | CAA-aLv4EyADS-+x9XYf1KMz_r7Lne-58WTeYDwNF9S6iEWMobw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Korotkov | 2013-09-17 08:58:42 | Re: GIN improvements part 1: additional information |
Previous Message | Cédric Villemain | 2013-09-17 07:37:16 | Re: PostgreSQL 9.3 beta breaks some extensions "make install" |