Re: BRIN cost estimate breaks geometric indexes

2020-02-14 Thread Komяpa
Hi, Patch may look as simple as this one: https://patch-diff.githubusercontent.com/raw/postgres/postgres/pull/49.diff Previous mention in -hackers is available at https://postgrespro.com/list/id/cakjs1f9n-wapop5xz1dtgdpdqmzegqqk4sv2mk-zzugfc14...@mail.gmail.com - seems everyone overlooked that pa

Re: BRIN cost estimate breaks geometric indexes

2020-01-20 Thread Egor Rogov
On 21.01.2020 0:00, Darafei "Komяpa" Praliaskouski wrote: Hi, Found out today that BRIN indexes don't really work for PostGIS and box datatypes. Since https://github.com/postgres/postgres/commit/7e534adcdc70866e7be74d626b0ed067c890a251 Postgres requires datatype to provide correlation stati

BRIN cost estimate breaks geometric indexes

2020-01-20 Thread Komяpa
Hi, Found out today that BRIN indexes don't really work for PostGIS and box datatypes. Since https://github.com/postgres/postgres/commit/7e534adcdc70866e7be74d626b0ed067c890a251 Postgres requires datatype to provide correlation statistics. Such statistics wasn't provided by PostGIS and box types.