Hello everyone,
I am attempting to set up a row level security policy based on geo-location
(and the PostGIS extension). I am struggling to have it make use of column
indexes.
The following example defines a table with geography points and aims to
restrict access to it based on distance to anothe
One possible optimisation occurred to me (that I guess we can’t currently do).
If we use a larger example with some correlation in r, we can see that the time
to execute the bitmap index scan is proportional to the number of items in the
IN/ANY disjunction:
drop table brin_test;
create table br
That makes perfect sense, thanks Simon!
Chris.
From: Simon Riggs
Sent: 21 June 2019 10:17
To: Chris Wilson
Cc: [email protected]
Subject: Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction
On Thu, 20 Jun 2019 at 16:13, Chris Wilson
mailto:chris.wil...@cantabcapital.
On Thu, 20 Jun 2019 at 16:13, Chris Wilson
wrote:
> With the following results:
>
>
>
> testing=# explain analyze select * from brin_test where id >= 9;
>
>QUERY PLAN
>
>
>
