<p dir="ltr"><br /> On May 24, 2016 5:27 PM, "David G. Johnston" <<a
href="mailto:david.g.johnston@gmail.com">david.g.johnston@gmail.com</a>>wrote:<br /> ><br /> > Moving my
gripingto -hackers only<br /> ><br /> > On Tue, May 24, 2016 at 8:08 PM, Tom Lane <<a
href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>>wrote:<br /> >><br /> >> <a
href="mailto:digoal@126.com">digoal@126.com</a>writes:<br /> >> > postgres=# create unlogged table u_tbl (id
int);<br/> >> > CREATE TABLE<br /> >> > postgres=# create index idx_u_tbl on u_tbl using bloom
(id);<br/> >> > ERROR: index "idx_u_tbl" already contains data<br /> >><br /> >> Yeah, it looks
likenobody ever tested bloom's unlogged-index support;<br /> >> it doesn't work or even come very close to
working. Will fix, thanks<br /> >> for the report!<br /> ><br /> ><br /> > I'll tack on my own gripe
here,just because.<br /> ><br /> > It doesn't give me a lot of confidence in what was committed when the summary
sentencefor the module says:<br /> ><br /> > "<br /> > bloom is a module which implements an index access
method.It comes as an example of custom access methods and generic WAL records usage. But it is also useful in
itself.<br/> > "<br /> ><br /> ><br /> > Honestly, as a user I couldn't care less that bloom is "an
examplecustom access method". I want to know what it does and that it does so reliably, and has a easy-to-use
interface. I complained earlier about its lack of direct support for the boolean type. Teodor's response on the thread
wasn'tparticularly encouraging:<br /> ><p dir="ltr">Given what a Bloom filter is/does, I'm having a hard time seeing
howit makes much sense to support the boolean type.<p dir="ltr">My biggest gripe with it at the moment is that the
signaturesize should be expressed in bits, and then internally rounded up to a multiple of 16, rather than having it be
expressedin 'uint16'.<p dir="ltr">If that were done it would be easier to fix the documentation to be more
understandable.<pdir="ltr">On the positive side, I've done extensive crash-recovery testing (not with unlogged tables,
obviously)and that part seems solid.<p dir="ltr">Cheers,<p dir="ltr">Jeff