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