Subject: Re: effective_io_concurrency on EBS/gp2
To: Claudio Freire <klaussfreire@gmail.com>
Cc: hzzhangjiazhi <hzzhangjiazhi@corp.netease.com>,
 Gary Doades <gpd@gpdnet.co.uk>, Rick Otten <rottenwindfish@gmail.com>,
 "pgsql-performance@lists.postgresql.org"
 <pgsql-performance@lists.postgresql.org>
References: <6c7a45df-f6ab-f2ce-6f84-9555864f6c86@gmail.com>
 <CAMAYy4+SPqTLuwjWLrnrAnZ2EVyz97oQ2Hey46fffP8tihaRXQ@mail.gmail.com>
 <768e3a56-46ed-3dd1-8722-953a47857a35@gmail.com>
 <014801d39a99$d4c32930$7e497b90$@gpdnet.co.uk>
 <8fb758a1-d7fa-4dcc-fb5b-07a992ae6a32@gmail.com>
 <CAGTBQpYCWStnzsjTrN+vBsEwZHH2PKwO7ybxp_JQv9CsEJj4xw@mail.gmail.com>
 <534b557c-3658-6d0f-2330-34a78da57e2f@gmail.com>
 <9122FC8B-2129-4E10-807F-F9F34117A156@corp.netease.com>
 <CAGTBQpZjj1ekDLyZ=RdyPhKAbLnow1ma66TDuBj=eradrgOskQ@mail.gmail.com>
 <c8b0b311-c436-622a-c5fa-96718ead36a0@gmail.com>
 <85a21d95-a776-4c1c-3223-5568864df3f3@gmail.com>
 <CAGTBQpZyXSxPuCFLBR3eg95=Lk3MexzaQdCGkuvH+vdKnN6gHg@mail.gmail.com>
From: Vitaliy Garnashevich <vgarnashevich@gmail.com>
Message-ID: <7895b3f0-0871-2b04-d3a3-3ade175e7212@gmail.com>
Date: Mon, 5 Feb 2018 13:26:43 +0200
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101
 Thunderbird/52.6.0
MIME-Version: 1.0
In-Reply-To: 
 <CAGTBQpZyXSxPuCFLBR3eg95=Lk3MexzaQdCGkuvH+vdKnN6gHg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Precedence: bulk

> I mean, that the issue is indeed affected by the order of rows in the
> table. Random heap access patterns result in sparse bitmap heap scans,
> whereas less random heap access patterns result in denser bitmap heap
> scans. Dense scans have large portions of contiguous fetches, a
> pattern that is quite adversely affected by the current prefetch
> mechanism in linux.
>

Thanks for your input.

How can I test a sparse bitmap scan? Can you think of any SQL commands 
which would generate data and run such scans?

Would a bitmap scan over expression index ((aid%1000)=0) do a sparse 
bitmap scan?

Regards,
Vitaliy