pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Justin Pryzby <pryzby@telsasoft.com>
To: Michael Lewis <mlewis@entrata.com>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: Chris Wilson <chris.wilson@cantabcapital.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction
Date: Thu, 20 Jun 2019 13:13:35 -0500
Message-ID: <20190620181335.GY16019@telsasoft.com> (raw)
In-Reply-To: <CAHOFxGpB_5dLgXe0+1ZQrn1TaO+BpCC3HFh4not5UVY4Dowccg@mail.gmail.com>
References: <BCCA73C2165E8947A2E786EC482564DE013E3562DA@CCPMAILDAG03.cantab.local>
	<CANP8+jKwFR2=Jjb30XQxVZaDo4knP4XbmS26sZVZ8yW9iaFV+Q@mail.gmail.com>
	<BCCA73C2165E8947A2E786EC482564DE013E35647C@CCPMAILDAG03.cantab.local>
	<CANP8+j++Vhbwh1V0hxrA_jeMzxuzzFh833-ere-iuob0KDE=Wg@mail.gmail.com>
	<20190620163044.GU16019@telsasoft.com>
	<CANP8+jKeswEqRUOdRJAhubL=FFxVRq9zmhwt3gPg2_7EFAP3xw@mail.gmail.com>
	<CAHOFxGpB_5dLgXe0+1ZQrn1TaO+BpCC3HFh4not5UVY4Dowccg@mail.gmail.com>

On Thu, Jun 20, 2019 at 12:09:13PM -0600, Michael Lewis wrote:
> For kicks I tried the example given and got the below which seems more
> expected.

Do you just mean that it ran faster the 2nd time ?  Isn't that just due just to
cache effects ?  Rerun them both back to back.

See that the "actual" rowcount of the Index Scan is higher with tigher
condition:

>   ->  Bitmap Index Scan on idx_brin_test_brin  (cost=0.00..3.32 rows=14286 width=0) (actual time=0.018..0.019 rows=640 loops=1)
>         Index Cond: (id >= 90000)

>   ->  Bitmap Index Scan on idx_brin_test_brin  (cost=0.00..3.31 rows=7143 width=0) (actual time=0.026..0.027 rows=1280 loops=1)
>         Index Cond: ((id >= 90000) AND (r = ANY ('{1,3}'::integer[])))





view thread (12+ messages)  latest in thread

Message-ID: <20190620181335.GY16019@telsasoft.com>
Permalink:  ../20190620181335.GY16019@telsasoft.com/
Also on:    postgresql.org/message-id/20190620181335.GY16019@telsasoft.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: pryzby@telsasoft.com, mlewis@entrata.com, simon@2ndquadrant.com, chris.wilson@cantabcapital.com
  Subject: Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction
  In-Reply-To: <20190620181335.GY16019@telsasoft.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox