Search Postgresql Archives

Re: Questions about btree_gin vs btree_gist for low cardinality columns

Subject: Re: Questions about btree_gin vs btree_gist for low cardinality columns
From: Morris de Oryx <morrisdeoryx@xxxxxxxxx>
Date: Sun, 2 Jun 2019 18:03:09 +1000
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <20190602073732.kvan34sfotdlyc7s@hjp.at>
References: <CAMa1XUiRZsg7Y5OBvau=orfVv=w=Rq19RDHQRySnF6RS=-+y2g@mail.gmail.com> <CAKqnccjrdoNne5D48-REhgNgRghc_2o453x1SWEoa8EYh792EQ@mail.gmail.com> <CAKqncciUyxY04GagOWYALE7+zOeF9a+AD=gYWV8PvJROw_YN7Q@mail.gmail.com> <20190601135313.z4pnwxcmbpeuzrq2@hjp.at> <CAKqncch73a0rff1sUb17eFCivLMV+sWhzxc2Bx2o_q1p3H4jGA@mail.gmail.com> <20190602073732.kvan34sfotdlyc7s@hjp.at>

Peter,

Thanks a lot for the remedial help on EXPLAIN and timing results.

References:
- Questions about btree_gin vs btree_gist for low cardinality columns
  - From: Jeremy Finzel
- Re: Questions about btree_gin vs btree_gist for low cardinality columns
  - From: Morris de Oryx
- Re: Questions about btree_gin vs btree_gist for low cardinality columns
  - From: Morris de Oryx
- Re: Questions about btree_gin vs btree_gist for low cardinality columns
  - From: Peter J. Holzer
- Re: Questions about btree_gin vs btree_gist for low cardinality columns
  - From: Morris de Oryx
- Re: Questions about btree_gin vs btree_gist for low cardinality columns
  - From: Peter J. Holzer