On Wed, 8 Jun 2022 at 08:31, David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
> So it does appear that the location index is being chosen, at least
> with the data that I inserted. Those gist indexes are costing quite a
> bit cheaper than the cheapest btree index.
This seems just to be because the gist indexes are smaller, which is
likely due to me having inserted NULL values into them.
postgres=# select pg_relation_size('logistic_site_key_key');
pg_relation_size
------------------
16384
(1 row)
postgres=# select pg_relation_size('logistic_site_location_54ae0166_id');
pg_relation_size
------------------
8192
(1 row)
David