On 17 September 2013 07:20, Jaime Casanova <ja...@2ndquadrant.com> wrote:
> On Mon, Sep 16, 2013 at 3:47 AM, Thom Brown <t...@linux.com> wrote: > > On 15 September 2013 01:14, Alvaro Herrera <alvhe...@2ndquadrant.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
