I stumbled upon this question:
https://dba.stackexchange.com/questions/229413
in a nutshell: the bloom index is not used with the example from the manual.
The bloom index is only used if either Seq Scan is disabled or if the
random_page_cost is set to 1 (anything about 1 triggers a Seq
Thomas Kellerer writes:
> The bloom index is only used if either Seq Scan is disabled or if the
> random_page_cost is set to 1 (anything about 1 triggers a Seq Scan on my
> Windows laptop).
Hm. blcostestimate is using the default cost calculation, except for
/* We have to visit all
On Tue, Feb 12, 2019 at 10:42 AM Tom Lane wrote:
> Thomas Kellerer writes:
> > The bloom index is only used if either Seq Scan is disabled or if the
> random_page_cost is set to 1 (anything about 1 triggers a Seq Scan on my
> Windows laptop).
>
> Hm. blcostestimate is using the default cost
On Tue, Feb 12, 2019 at 11:58 AM Jeff Janes wrote:
>
> On Tue, Feb 12, 2019 at 10:42 AM Tom Lane wrote:
>
>>
>> Hm. blcostestimate is using the default cost calculation, except for
>>
>> /* We have to visit all index tuples anyway */
>> costs.numIndexTuples = index->tuples;
>>
On Tue, Feb 12, 2019 at 4:23 AM Jung, Jinho wrote:
>
> Hello,
>
> We are developing a tool called sqlfuzz for automatically finding
> performance regressions in PostgreSQL. sqlfuzz performs mutational fuzzing
> to generate SQL queries that take more time to execute on the latest
> version of
On Tue, Feb 12, 2019 at 4:17 PM Tom Lane wrote:
> Jeff Janes writes:
> > In order for bloom (or any other users of CREATE ACCESS METHOD, if there
> > are any) to have a fighting chance to do better, I think many of
> selfuncs.c
> > currently private functions would have to be declared in some
Jeff Janes writes:
> In order for bloom (or any other users of CREATE ACCESS METHOD, if there
> are any) to have a fighting chance to do better, I think many of selfuncs.c
> currently private functions would have to be declared in some header file,
> perhaps utils/selfuncs.h. But that then
Re: Jung, Jinho 2019-02-11
> We are developing a tool called sqlfuzz for automatically finding performance
> regressions in PostgreSQL. sqlfuzz performs mutational fuzzing to generate
> SQL queries that take more time to execute on the latest version of
> PostgreSQL compared to prior
Hello,
We are developing a tool called sqlfuzz for automatically finding performance
regressions in PostgreSQL. sqlfuzz performs mutational fuzzing to generate SQL
queries that take more time to execute on the latest version of PostgreSQL
compared to prior versions. We hope that these queries