Re: pgsql: Bloom index contrib module

On 2016-04-01 14:36, Erik Rijkers wrote:
> On 2016-04-01 15:49, Teodor Sigaev wrote:
>> Bloom index contrib module
>>
>> doc/src/sgml/bloom.sgml          | 218 ++++++++++++++++++
>


The size of example table (in bloom.sgml):

CREATE TABLE tbloom AS
SELECT
     random()::int as i1,
     random()::int as i2,
[...]
     random()::int as i12,
     random()::int as i13
FROM
     generate_series(1,1000);

seems too small to demonstrate the index-use.

For me, both on $BigServer at work as on $ModestDesktop at home the 1000
rows are not enough.

I suggest making the rowcount in that example a larger, for instance
10000, so: generate_series(1,10000).

Does that make sense?  I realize the behavior is probably somewhat
dependent from hardware and settings...


thanks,


Erik Rijkers