Re: [PATCH] bitmap indexes - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: [PATCH] bitmap indexes
Date
Msg-id CAJKUy5gXzRTtXbKMak7PKw3A9uSY_76ZSe9Q3umRCW0Xsfvp8g@mail.gmail.com
Whole thread Raw
In response to [PATCH] bitmap indexes  (Abhijit Menon-Sen <ams@2ndquadrant.com>)
Responses Re: [PATCH] bitmap indexes
List pgsql-hackers
On Sat, Sep 14, 2013 at 1:14 PM, Abhijit Menon-Sen <ams@2ndquadrant.com> wrote:
> Hi.
>
> This is a cleaned-up and rebased version of the bitmap index patch from
> Gavin Sherry, later revised by Gianni Ciolli and Gabriele Bartolini, and
> others including Daniel Bausch.
>

Hi Abhijit,

Please, in the next update consider this messages i'm getting when
compiling with your patch.
"""
bitmapxlog.c: In function ‘bitmap_xlog_cleanup’:
bitmapxlog.c:658:32: warning: ‘reln’ may be used uninitialized in this
function [-Wuninitialized]
selfuncs.c: In function ‘bmcostestimate’:
selfuncs.c:7327:13: warning: unused variable ‘indexCorrelation’
[-Wunused-variable]
selfuncs.c:7326:15: warning: unused variable ‘indexSelectivity’
[-Wunused-variable]
selfuncs.c:7325:11: warning: unused variable ‘indexTotalCost’
[-Wunused-variable]
selfuncs.c:7324:11: warning: unused variable ‘indexStartupCost’
[-Wunused-variable]
"""

Also, there are 2 regression tests failing (attached regression.diffs)

And this error, when trying to generate docs
"""
openjade:bitmap.sgml:123:85:X: reference to non-existent ID
"SQL-CREATEINDEX-TITLE"
"""

And finally, i was excercising the feature in some ways and got a
crash when creating an index concurrently (attached
index_failure.txt), it wasn't just a crash i couldn't start up the
server again after it

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566         Cell: +593 987171157

Attachment

pgsql-hackers by date:

Previous
From: Satoshi Nagayasu
Date:
Subject: Re: [PoC] pgstattuple2: block sampling to reduce physical read
Next
From: Oleg Bartunov
Date:
Subject: \h open